Post reply

How can I find user permissions on stored proce thatdures

  • October 22, 2012 at 10:59 am

    #283881

    Hi

    Is there a way I can query to see the user permissions for all the stored procedures? I know I can use sp_helptext for a single stored procedure but I would like to view them all.

  • October 22, 2012 at 11:06 am

    #1551542

    Sorry about the typo on the title.

  • October 26, 2012 at 3:34 am

    #1553074

    USE Databasename;

    EXECUTE AS USER = 'username';

    SELECT *

    FROM sys.fn_my_permissions('procedurename ', 'object')

    ORDER BY subentity_name, permission_name ;

    GO

    This script can be use d as base to identify permission on a stored procedure for a particular user

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

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