Collection Contents Index SYSSUBSCRIPTIONS system view SYSTRIGGERS system view pdf/chap16.pdf

Reference Manual
   CHAPTER 16. System Views     

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.


Collection Contents Index SYSSUBSCRIPTIONS system view SYSTRIGGERS system view pdf/chap16.pdf