MS SQL Server: Check to see if a user can execute a stored procedure -


How can you see that the user can execute a stored operation in a MS SQL server?

I can see that the user executes clear permissions to execute and execute from the main database:

  databasename..sp_helpprotect 'storedProcedureName', 'username'  

However sp_helprotect will not help me if the user is a member of a role that has permissions.

Ideally I want to be able to make some such calls

  Databasanam..spaaxextrack 'cached previewname', 'username'  

That will return a bull.

and


Comments