Sybase Adaptive Server Anywhere - SYSCOLAUTH System View

Chapter 16 System Views
1057
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.