Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


COLUMN_PRIVILEGES


Records table or view columns that depend on other objects in the database.

.
Column name
Data type
Description

TABLE_SYSID

INTEGER

System identifier for the table or view.

COLUMN_NAME

VARCHAR(128)

The name of the table or view column.

PRIVILEGE_TYPE

CHAR(20)

One of:
"INSERT"
"REFERENCES"
"SELECT"
"UPDATE".

GRANTEE

VARCHAR(128)

The name of the ident to which the privilege was granted.

GRANTOR

VARCHAR(128)

The name of the ident granting the privilege.

IS_GRANTABLE

CHAR(3)

One of:
"NO" = WITH GRANT OPTION is not held for the privilege
"YES" = WITH GRANT OPTION is held for the privilege.

IS_INSTEAD_OF

CHAR(3)

One of:
"NO" = The privilege has been granted explicitly
"YES" = The privilege is granted because an instead of trigger has been defined on the view to which the column belongs.

Primary key: TABLE_SYSID, COLUMN_NAME, PRIVILEGE_TYPE, GRANTEE, GRANTOR

Secondary index: GRANTEE

Secondary index: GRANTOR



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL System Management Handbook TOC PREV NEXT INDEX