Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kworn
Starting Member
7 Posts |
 Posted - 2007-01-15 : 09:43:58
|
| I am supporting a system that needs to allow users to have access to TempDB. I set these users up using the GUI, but whenever the server is restarted, these users permissions are wiped out and the db_owner permission is lost and I have to manually go in and apply the permissons for the database to work again, it happens on most reboots but not all.Is there anyway to keep these users permissions when the server is rebooted?Your help is most appriciated.P.S Could I create a stored procedure that when ever the Server is rebooted the procedure would recreate these permissions?If I need to do this how would I go about doing this? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-15 : 13:19:17
|
| It happens on all reboots as tempdb is rebuilt each time the SQL Server service is started, which occurs on startup. You could add your settings to the model database so that when tempdb is rebuilt it uses those settings. But those settings will also be applied to any new databases that are created as well.Second option is to create a job that applies the settings. Have the job start whenever the SQL Agent is started (it's one of the options when configuring a job).Tara Kizer |
 |
|
|
Kworn
Starting Member
7 Posts |
Posted - 2007-01-16 : 09:47:11
|
| I wish it was that easy but I have no control over the system that accesses the database.I know it has been setup wrong and they dont want to do it the right way. If it aint broke dont fix it. But I still need this database to work if and when the server reboots.Could anyone help me with creating an SP that can put these database permissions back in? I have no real skills in this area.Thank you |
|
|
|
|
|
|
SQL Server 2000 tempDB user losing permissions