Collection Contents Index SYSCATALOG system view SYSCOLUMNS system view pdf/chap16.pdf

Reference Manual
   CHAPTER 16. System Views     

SYSCOLAUTH system view


CREATE VIEW SYS.SYSCOLAUTH ( grantor, grantee,
   creator, tname, colname )
AS
SELECT ( SELECT user_name FROM SYS.SYSUSERPERM
         WHERE user_id = SYSCOLPERM.grantor ),
      ( SELECT user_name FROM SYS.SYSUSERPERM
         WHERE user_id = SYSCOLPERM.grantee ),
      ( SELECT user_name
         FROM SYS.SYSUSERPERM == SYS.SYSTABLE
         WHERE table_id = SYSCOLPERM.table_id ),
      ( SELECT table_name FROM SYS.SYSTABLE
         WHERE table_id = SYSCOLPERM.table_id ),
      ( SELECT column_name FROM SYS.SYSCOLUMN
         WHERE table_id = SYSCOLPERM.table_id
         AND column_id = SYSCOLPERM.column_id )
FROM SYS.SYSCOLPERM

Presents column update permission information in SYSCOLPERM in a more readable format.


Collection Contents Index SYSCATALOG system view SYSCOLUMNS system view pdf/chap16.pdf