Post reply

can't view all db_users when select * from sys.databaseprincipals

  • March 27, 2013 at 5:42 pm

    #1601429

    OK folks, I have had sysadmin permissions, so I should be able to list all db_users...to prove it to myself that sysadmin is good enough,I have just created a sql server login and altered.

    So is it possible to get a lead as to what the stored procedure needs to be able to do so that I can list all db_users? Will this be straight SQL and against which tables?

  • March 27, 2013 at 5:52 pm

    #1601430

    Lynn, I'm a DBA, it turns out. Does that mean that the list I am getting when I do select * from sys.database_principals is complete afterall?

  • March 27, 2013 at 6:14 pm

    #1601432

    KoldCoffee (3/27/2013)

    Lynn, I'm a DBA, it turns out. Does that mean that the list I am getting when I do select * from sys.database_principals is complete afterall?

    If you have sysadmin rights while running the query you have, you are seeing all the database principals.

  • March 27, 2013 at 8:33 pm

    #1601441

    Thank you, Lynn.

    --Quote me

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply