Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Reference » System Objects » Views » System views

 

SYSCOLPERM system view

The GRANT statement can give UPDATE, SELECT, or REFERENCES permission to individual columns in a table. Each column with UPDATE, SELECT, or REFERENCES permission is recorded in one row of the SYSCOLPERM system view. The underlying system table for this view is ISYSCOLPERM.

Column name Column type Description
table_id UNSIGNED INT The table number for the table containing the column.
grantee UNSIGNED INT The user number of the user ID that is given permission on the column. If the grantee is the user number for the special PUBLIC user ID, the permission is given to all user IDs.
grantor UNSIGNED INT The user number of the user ID that grants the permission.
column_id UNSIGNED INT This column number, together with the table_id, identifies the column for which permission has been granted.
privilege_type SMALLINT The number in this column indicates the kind of column permission (16=REFERENCES, 1=SELECT, or 8=UPDATE).
is_grantable CHAR(1) Indicates if the permission on the column was granted WITH GRANT OPTION.
Constraints on underlying system table

PRIMARY KEY (table_id, grantee, grantor, column_id, privilege_type)

FOREIGN KEY (table_id, column_id) references SYS.ISYSTABCOL (table_id, column_id)

FOREIGN KEY (grantor) references SYS.ISYSUSER (user_id)

FOREIGN KEY (grantee) references SYS.ISYSUSER (user_id)