Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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 28, 2016 1:55 PM
Points: 196, Visits: 263
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: Thursday, October 13, 2016 1:22 AM
Points: 1,416, Visits: 2,931
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 28, 2016 1:55 PM
Points: 196, Visits: 263
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 @ 7:18 AM
Points: 14,545, Visits: 38,405
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

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
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 28, 2016 1:55 PM
Points: 196, Visits: 263
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 @ 6:59 AM
Points: 7,033, Visits: 14,724
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