Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


USAGE_PRIVILEGES


The USAGE_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 character sets and collations.

Column name
Data type
Description
GRANTOR
VARCHAR(128)
The name of the ident who granted the privilege.
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.
OBJECT_CAT
VARCHAR(128)
The name of the catalog that contains the object character set or collation.
OBJECT_SCHEM
VARCHAR(128)
The name of the schema that contains the object character set or collation.
OBJECT_NAME
VARCHAR(128)
The name of the character set or collation.
OBJECT_TYPE
VARCHAR(20)
One of:
"CHARACTER SET" = the privilege is held on a character set
"COLLATION" = the privilege is held on a collation.
PRIVILEGE_TYPE
VARCHAR(20)
This will always be "USAGE".
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