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 in SYSTABLEPERM in a more readable format.