You are here

SQL Server – Find Stored Procedures User Can Access

Returns a report that has information about user permissions for an object, or statement permissions, in the current database.

To find stored procedures that “username” can access:


exec sp_helprotect @username = 'username'

To see all objects in database and who has access:


exec sp_helprotect

For complete capabilities see http://msdn.microsoft.com/en-us/library/ms190310.aspx

Categories: 
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
1 + 13 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer