Post reply

How to view sys.database_principals

  • October 7, 2008 at 10:25 am

    #198951

    I'm sure this is an extremely simple problem. I'm studying Wrox's Beginning SQL Server 2005 Administration. Throughout the book there are 'For More Information' sections that state "The following Security Catalog Views can be used to identify....". I'll be darned if I can find a way to view either of two views named sys.database_principals and sys.database_role_members. Obviously I am a newbie. Can anyone help me with this? Thanks. Victor Victor

  • October 7, 2008 at 10:54 am

    #881819

    What do you get when you run "select * from sys.database_principals"

    .

  • October 7, 2008 at 11:06 am

    #881827

    Your hint worked. I won't go any further with this since I can now proceed. However, I did try select * from sys.database_principals yesterday. Query worked but returned zero rows. Also tried EXEC as though it was a stored procedure which did not work either. Can't explain. But: THANKS. I just hate it when I can do the difficult stuff but something simple stumps me. Thanks again, Victor Victor.

Viewing 3 posts - 1 through 2 (of 2 total)

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