Contents Index SYSCOLLATIONMAPPINGS system table SYSCOLSTAT system table

ASA SQL Reference
  System Tables

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 statement 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.


Contents Index SYSCOLLATIONMAPPINGS system table SYSCOLSTAT system table