Sybase Adaptive Server Anywhere - SYSCOLPERM System Table

Chapter 15 System Tables
1003
SYSCOLPERM system table
Column name Column type
Column
constraint
Table constraint
table_id UNSIGNED INT NOT NULL Primary key, foreign
key references
SYSCOLUMN
grantee UNSIGNED INT NOT NULL Primary key, foreign
key references
SYSUSERPERM.user_
id
grantor UNSIGNED INT NOT NULL Primary key, foreign
key references
SYSUSERPERM.user_
id
column_id UNSIGNED INT NOT NULL Primary key, foreign
key references
SYSCOLUMN
privilege_type SMALLINT NOT NULL Primary key
is_grantable CHAR(1) NOT NULL
The GRANT command can give UPDATE permission to individual columns
in a table. Each column with UPDATE permission is recorded in one row of
SYSCOLPERM.
table_id The table number for the table containing the column.
grantee The user number of the user ID that is given UPDATE permission
on the column. If the grantee is the user number for the special PUBLIC
user ID, the UPDATE permission is given to all user IDs.
grantor The user number of the user ID that grants the permission.
column_id This column number, together with the table_id, identifies the
column for which UPDATE permission has been granted.
privilege_type The number in this column indicates the kind of column
permission (REFERENCES, SELECT or UPDATE).
is_grantable (Y/N) Indicates if the permission on the column was granted
WITH GRANT OPTION.