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.