February 1, 2006 at 10:59 am
Good day,
About a week ago, we moved the SQL Server 2000 sp4 from one server to a newer bigger sever. First, I detached all DB's, restored the master, then the msdb and model, then started restoring DB's. All was well, untill today, it appears that the permissions for the users were lost. I can compare them against the production box, but I want to know two things...
1. What did I do wrong to lose the permissions (IE - default DB, Sysadmin roles for some, data write)
2. Is there a way I can see all the logins and the permissions they have at a glance, instead of going through each user to get each permission?
Thanks in advance!
Cory
-- Cory
February 1, 2006 at 12:13 pm
I take it that these were not Windows Account users?
A login has an SID number which is unique to the box. SID 1 is the SA account.
If you recreated the logins then used sp_change_users_login 'AUTO_FIX','YourUser' your permissions may have stayed in place I cannot say for sure.
Personally I assign permissions to roles and make users members of the appropriate roles.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply