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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2012-11-27 : 05:18:15
|
| Hi,Here is the database settings:There is domainName\users unders security\ logins.db_owner is NOT checked for database1Then I go to database1, security\users.I only see users. Notice that it is not domainName\users. It is just usersQuestion: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
39 Posts |
Posted - 2012-11-27 : 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