Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to retrive stored procedures having execute permission for a user

Status
Not open for further replies.
sparkme

sparkme

Programmer
Oct 3, 2003
30
US

I have a user called Report in a database.I want to find all the stored procedures on which this user is having EXECUTE permission in the database.

Can any of you tell me which system tables and how this can be queried?

Thanks
 
Sort by date Sort by votes
what version of SQL Server?

- Paul
- If at first you don't succeed, find out if the loser gets anything.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
How to add a Letter to datepart
Replies
5
Views
296
Andrzejek
Andrzejek
dgillz
  • Locked
  • Question
How to convert varchar to time? 2
Replies
1
Views
447
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
343
BobSuruncle
BobSuruncle
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
238
Chris Miller
Chris Miller
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
364
Volvere
V

Part and Inventory Search

Sponsor

Back
Top