Post reply

View user permissions on a database

  • April 8, 2011 at 2:18 am

    #236371

    I want to check all the details of an user in a database.

    It's a user who has only a costum made database role.

    So I need to have a script to view all datails of the permissions of that user (or beter: database role).

    Many thanks.

  • April 8, 2011 at 2:30 am

    #1309010

    You should be able to get all the information you need from the sys.database_permissions system view.

    John

  • April 8, 2011 at 3:02 am

    #1309018

    Ok thanks, found it.

    My problem was the database role.

    I only checked the user (thought the permission of the role were listed too...) and I've to check both principals.

    Many thanks.

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

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