SYSCOLPERM system table

Reference Manual
CHAPTER 15. System Tables

SYSCOLPERM system table

Column name

Column type

Column constraint

Table constraint

table_id

SMALLINT

NOT NULL

Primary key, foreign key references SYS.SYSCOLUMN

grantee

SMALLINT

NOT NULL

Primary key, foreign key references SYS.SYSUSERPERM

grantor

SMALLINT

NOT NULL

Primary key, foreign key references SYS.SYSUSERPERM.user_id

column_id

SMALLINT

NOT NULL

Primary key, foreign key references SYS.SYSCOLUMN

privilege_type

SMALLINT

NOT NULL

Primary key

is_grantable

CHAR(1)

NOT NULL

Column name	Column type	Column constraint	Table constraint
table_id	SMALLINT	NOT NULL	Primary key, foreign key references SYS.SYSCOLUMN
grantee	SMALLINT	NOT NULL	Primary key, foreign key references SYS.SYSUSERPERM
grantor	SMALLINT	NOT NULL	Primary key, foreign key references SYS.SYSUSERPERM.user_id
column_id	SMALLINT	NOT NULL	Primary key, foreign key references SYS.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.