• 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