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
Post a Comment