|
arkiboys
Flowing Fount of Yak Knowledge
1346 Posts |
 Posted - 11/27/2012 : 05:18:15
|
Hi,
Here is the database settings:
There is domainName\users unders security\ logins.
db_owner is NOT checked for database1
Then I go to database1, security\users.
I only see users. Notice that it is not domainName\users. It is just users
Question:
Why is it that the db_owner is checked but greyed out in the general tab ?
db_owner should not be checked.
Any thoughts please?
Thanks
|
|
|
Elizabeth B. Darcy
Starting Member
United Kingdom
39 Posts |
Posted - 11/27/2012 : 11:23:39
|
They could be orphaned users. Did you restore the database from another server? You can compare the SIDs from sys.sysusers and sys.syslogins to see if they are indeed orphaned users. If they are orphaned, there are many examples and blogs and MSDN pages about how to fix.
________________________________________
-- Yes, I am indeed a fictional character. |
 |
|
user permission
