I hope I can explain this correctly. My SQL Server administrator has given me permission to create Tables in the TEMPDB. This works fine until he has to reboot the TEMPDB and then I lose those rights. What would be a permanent solution, so he doesn't have to set me up everytime the TEMPDB is rebooted? Or is this possible?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
TEMPDB..How do you set it up?
- Thread starter e7akerson
- Start date
tlbroadbent
MIS
TempDB is recreated everytime SQL Server is restarted. All objects, permissions, etc are completely replaced. If you need an error to create tables and other objects, have the DBA create a working database for you with all the permissions you require. Terry
The reason why worry kills more people than work is that more people worry than work. - Robert Frost
The reason why worry kills more people than work is that more people worry than work. - Robert Frost
- Status
Similar threads
- Locked
- Question
