Post reply

Users/groups

  • September 20, 2012 at 1:57 pm

    #281985

    Hello

    I need to get all users/groups from all databases and what type of access each user/group has,how can I get it?

    Thank you

  • September 20, 2012 at 2:08 pm

    #1540372

    I'd start with the sys.server_principals (server level) and sys.database_principals (database level, in each database) system views. Look these up in Books Online for more information on them.

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

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