Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005

    Unanswered: How to View User Permission?

    Can anyone tell me how to extract user and group permissions for all users in syslogins table from all databases of the server

  2. #2
    Join Date
    Dec 2004
    the user and group permissions are maintained in the sysprotects table in each database.
    also, it would be advisable to match it against sysusers rather than syslogins because all logins may not be users in each database.

    sp_helprotect <object name> gives you the required information.

  3. #3
    Join Date
    Jan 2005
    The procedure sp_helprotect will also give you all of the permission for a user or group if you supply the user (name in database) or group name.

Posting Permissions

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