March 27, 2013 at 5:42 pm
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
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
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
Thank you, Lynn.
--Quote me
Viewing 4 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy