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 |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2005-12-12 : 07:15:51
|
Don Matykowski writes "I assign my users to public and set "select" permissions in the public role. When I reboot the server, the public user loses 1/2 of the select permissions. I have to go in and reset the "select" permission every time.Very annoying for the user if I don't get at it first thing after a reboot." |
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2005-12-12 : 14:18:40
|
Are you possibly doing a Restore database or something prior to the reboot? |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2005-12-13 : 00:49:51
|
Hi,rather why dont make a seprate user role and assign proper permission to that user and then add / map your user to that role , it will serve your purpose.:-)RegardsAndy DavisActivecrypt Team--------------------------------------------SQL Server Encryption Softwarehttp://www.activecrypt.com |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-12-13 : 09:46:46
|
Are there any errors in the errorlog around the recovery of this database? |
|
|
|
|
|