What are the challenges you face when working across database platforms? Take the survey
Options

Show all permissions on a database for a particular user

gsuttiegsuttie Posts: 80
edited November 16, 2007 8:47AM in SQL Compare Previous Versions
Hi Folks

What tool would I use to find out what execute permission UserA has on the database stored procs?

Is there a tool I can use to select a user and see what rights they have at every level?

Cheers
Gregor

Comments

  • Options
    gsuttie wrote:
    Hi Folks

    What tool would I use to find out what execute permission UserA has on the database stored procs?

    Is there a tool I can use to select a user and see what rights they have at every level?

    Cheers
    Gregor

    Hi Gregor,

    If you are looking for the effective permissions, i.e. that consider the role membership of a user, and the permissions assigned to both the roles and the users, then you could use Microsoft's Management Studio. In the Object Explorer find the user, select properties, Securables, Effective Permissions.

    SQL Compare can show you the database level permissions for users, however object level permissions, following Microsoft's format of script creation, are shown with the database objects.

    Regards,
    Andras
    András Belokosztolszki, PhD
    Red Gate Software Ltd.
Sign In or Register to comment.