Sybase Adaptive Server Anywhere - SYSTABAUTH System View

SYSTABAUTH system view
1070
SYSTABAUTH system view
CREATE VIEW SYS.SYSTABAUTH ( grantor, grantee,
screator, stname, tcreator, ttname,
selectauth, insertauth, deleteauth,
updateauth, updatecols, alterauth, referenceauth )
AS
SELECT ( SELECT user_name FROM SYS.SYSUSERPERM
WHERE user_id = SYSTABLEPERM.grantor ),
( SELECT user_name FROM SYS.SYSUSERPERM
WHERE user_id = SYSTABLEPERM.grantee ),
( SELECT user_name
FROM SYS.SYSUSERPERM == SYS.SYSTABLE
WHERE table_id = SYSTABLEPERM.stable_id ),
( SELECT table_name FROM SYS.SYSTABLE
WHERE table_id = SYSTABLEPERM.stable_id ),
( SELECT user_name FROM
SYS.SYSUSERPERM == SYS.SYSTABLE
WHERE table_id = SYSTABLEPERM.ttable_id ),
( SELECT table_name FROM SYS.SYSTABLE
WHERE table_id = SYSTABLEPERM.ttable_id ),
selectauth, insertauth, deleteauth,
updateauth, updatecols,
alterauth, referenceauthauth
FROM SYS.SYSTABLEPERM
Presents table permission information from SYSTABLEPERM in a more
readable format.