Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

user permission Expand / Collapse
Author
Message
Posted Tuesday, November 27, 2012 3:17 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 17, 2014 7:28 AM
Points: 155, Visits: 202
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
Post #1389048
Posted Tuesday, November 27, 2012 3:42 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 4:40 AM
Points: 1,380, Visits: 2,699
arkiboys (11/27/2012)
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


The Login is probably the owner of the database and therefore doesn't show up under database users

What is the output of this:
sp_helpdb 'database_name'



Post #1389055
Posted Tuesday, November 27, 2012 4:10 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 17, 2014 7:28 AM
Points: 155, Visits: 202
SQLSACT (11/27/2012)
arkiboys (11/27/2012)
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


The Login is probably the owner of the database and therefore doesn't show up under database users

What is the output of this:
sp_helpdb 'database_name'




The owner is administrator
Post #1389071
Posted Tuesday, November 27, 2012 5:58 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:45 PM
Points: 12,905, Visits: 32,182
i believe if a login belongs to the sysadmin group, and you create a user for the login in any database, the db)owner checkbox gets inherited as readonly ; that's what you are seeing, i think.

can you check the login and see if it is a sysadmin?

also check to see if the windows group is sysadmin, and since the user belongs to that group, it's the same effective permissions.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1389134
Posted Tuesday, November 27, 2012 6:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 17, 2014 7:28 AM
Points: 155, Visits: 202
Lowell (11/27/2012)
i believe if a login belongs to the sysadmin group, and you create a user for the login in any database, the db)owner checkbox gets inherited as readonly ; that's what you are seeing, i think.

can you check the login and see if it is a sysadmin?

I checked and it is NOT a member of sysadmin
Post #1389136
Posted Tuesday, November 27, 2012 6:20 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:06 AM
Points: 5,430, Visits: 10,108
Maybe you have an orphaned user. If you look at the properties of the user, what does it say next to Login name? If it's blank, try dropping the user and recreating it from the login.

John
Post #1389145
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse