Collection Contents Index SYSOPTIONS system view SYSPROCPARMS system view pdf/chap16.pdf

Reference Manual
   CHAPTER 16. System Views     

SYSPROCAUTH system view


CREATE VIEW SYS.SYSPROCAUTH(grantee,
      creator,procname)
AS
SELECT(select user_name FROM SYS.SYSUSERPERM
      WHERE SYSPROCPERM.grantee=SYSUSERPERM.user_id),
       (select user_name FROM SYS.SYSUSERPERM
      WHERE SYSPROCEDURE.creator=SYSUSERPERM.user_id),
      proc_name 
FROM
SYS.SYSPROCEDURE JOIN SYS.SYSPROCPERM

Presents the procedure authorities from SYSUSERPERM in a more readable format.


Collection Contents Index SYSOPTIONS system view SYSPROCPARMS system view pdf/chap16.pdf