Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2006
    Location
    USA
    Posts
    115

    Unanswered: Database users list and role assigned

    Hi,

    Is there any way to get database users list, database name, role assigned ?

    Same way I want to fetch SQL Server Login, assinged system role list.
    Rajesh Patel

    Everybody says - mistake is the first step of success, but it's not true. The correction of the mistake is the first step of success.

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    I guess .. you are looking for sys.database_principals and sys.database_role_members .... not sure coz i dont have a server nearby right now ... but try them out and let me know what you miss ...
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Jan 2006
    Location
    USA
    Posts
    115
    Quote Originally Posted by Enigma
    I guess .. you are looking for sys.database_principals and sys.database_role_members .... not sure coz i dont have a server nearby right now ... but try them out and let me know what you miss ...
    Thanks for reply...

    I have tried all these but not getting the result I want. I am looking for a script which can list me all member of db_owners.
    Rajesh Patel

    Everybody says - mistake is the first step of success, but it's not true. The correction of the mistake is the first step of success.

  4. #4
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    ok ... let me whip you up a query first thing in the morning tomorrow ...
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •