CREATE TABLE SYS.SYSCOLPERM ( table_id UNSIGNED INT NOT NULL, grantee UNSIGNED INT NOT NULL, grantor UNSIGNED INT NOT NULL, column_id UNSIGNED INT NOT NULL, privilege_type SMALLINT NOT NULL, is_grantable CHAR( 1 ) NOT NULL, PRIMARY KEY ( table_id, grantee, grantor, column_id, privilege_type ), FOREIGN KEY grantee ( grantee ) REFERENCES SYS.SYSUSERPERM ( user_id ), FOREIGN KEY grantor ( grantor ) REFERENCES SYS.SYSUSERPERM ( user_id ), FOREIGN KEY REFERENCES SYS.SYSCOLUMN )
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 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 granting 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 by the grantor to the grantee WITH GRANT OPTION.
