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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
tempdb permission removed on reboot?
- Thread starter gcole
- Start date
tempdb is rebuilt from 'scratch' every time SQL Server is restarted.
It rebuilds it based on Model. You could try giving the person permission to Model and Tempdb, stopping SQL Server and restarting it, then seeing if they still have permissions to tempdb. But why are you allowing users to do things in tempdb? It's just what it's named - a temporary database. Users should be creating or using their own database(s).
-SQLBill
It rebuilds it based on Model. You could try giving the person permission to Model and Tempdb, stopping SQL Server and restarting it, then seeing if they still have permissions to tempdb. But why are you allowing users to do things in tempdb? It's just what it's named - a temporary database. Users should be creating or using their own database(s).
-SQLBill
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Helpful tip