display execute rights on procedures and functions of all user

April 9, 2009
 
SELECT t1.user_id,
       t1.user_name,
       t3.proc_id,
       t3.proc_name AS 'Function or Procedure'
FROM sysuserperm t1, sysprocperm t2, sysprocedure t3
WHERE t1.user_id = t2.grantee
AND t2.proc_id = t3.proc_id
AND user_group = 'Y'
AND t1.user_id >=101 -- fading out system users
 

tags: , ,
posted in asiq by Frank

 
Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org