Sybase Adaptive Server Anywhere - SYSPROCAUTH System View

Chapter 16 System Views
1063
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.