Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


TABLE_PRIVILEGES


The TABLE_PRIVILEGES system view lists privileges that were granted by the current ident, and privileges that were granted to the current ident or to PUBLIC, on an entire table.

An entry in this view does not assert that the grantee holds the privilege on any specific column of the table, because privileges can be granted on a table and then revoked on individual columns.

Information about privileges on specific columns is presented in the COLUMN_PRIVILEGES view.

Column name
Data type
Description
GRANTOR
VARCHAR(128)
The name of the ident who granted the privilege. For rows that describe the implicit privileges that a table creator has on each column in a table, the name "_SYSTEM" is shown.
GRANTEE
VARCHAR(128)
The name of the ident to whom the privilege was granted. Granting a privilege to PUBLIC will result in only one row (per privilege granted) in this view and the name "PUBLIC" will be shown.
TABLE_CAT
VARCHAR(128)
The name of the catalog containing the table.
TABLE_SCHEM
VARCHAR(128)
The name of the schema containing the table.
TABLE_NAME
VARCHAR(128)
The name of the table in question.
PRIVILEGE_TYPE
VARCHAR(20)
A value describing the type of the column privilege that was granted. One of:
DELETE
INSERT
REFERENCES
SELECT
UPDATE.
Rows where privilege type is REFERENCES or UPDATE only describe cases where the grantee was granted the privilege on the entire table. Where the GRANT statement granted REFERENCES or UPDATE privilege to specified columns of a table, no rows appear in TABLE_PRIVILEGES but there are rows in COLUMN_PRIVILEGES.
Note that when multiple table privileges are granted to the same user at the same time (e.g. when the keyword "ALL" is used), multiple rows appear in this view (one for each privilege granted).
IS_GRANTABLE
VARCHAR(3)
One of:
"YES" = the privilege is held with the WITH GRANT OPTION
"NO" = the privilege is held without the WITH GRANT OPTION.
REMARKS
VARCHAR(254)
May contain descriptive information about the privilege.



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