Imke Cronje
SSCarpal Tunnel
Points: 4826
More actions
January 25, 2008 at 2:26 am
#121906
Hi there,
Is there perhaps a way in SQL where you can display a list of stored procs on a database with the logins associated to that stored proc. eg. a list of user logins may have execute permissions on a stored proc.
Please Help
IC
John Mitchell-245523
SSC Guru
Points: 148809
January 25, 2008 at 2:36 am
#771626
Yes, there is. Look up the sys.database_permissions metadata view.
John
ChiragNS
One Orange Chip
Points: 26137
January 25, 2008 at 3:44 am
#771637
will it show a list of stored procs ?
"Keep Trying"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply