Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


TABLE_PRIVILEGES


Records instances of privileges granted on a table.

Column name
Data type
Description

TABLE_SYSID

INTEGER

System identifier of the table.

PRIVILEGE_TYPE

CHAR(20)

One of:
"DELETE"
"INSERT"
"LOAD"
"REFERENCES"
"SELECT"
"UPDATE"
"TRIGGER".

GRANTEE

VARCHAR(128)

The name of the ident to whom the table privilege was granted.

GRANTOR

VARCHAR(128)

The name of the ident granting the table privilege.

IS_GRANTABLE

CHAR(3)

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

IS_INSTEAD_OF

CHAR(3)

One of:
"NO" = The privilege was granted explicitly
"YES" = The privilege was granted implicitly when an instead of trigger was created.

IS_ON_TABLE

CHAR(3)

One of:
"NO" = The privilege was granted on individual columns
"YES" = The privilege was granted on the complete table.

ALL_COLUMNS

CHAR(3)

One of:
"YES" = the privilege was granted on the table and therefore applies to all table columns, including new ones added
"NO" = the privilege only applies to the table columns explicitly specified when the privilege was granted.

Primary key: TABLE_SYSID, 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