Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


USAGE_PRIVILEGES


Records instances of privileges which grant the right to use a database object.

Column name
Data type
Description

OBJECT_SYSID

INTEGER

System identifier of the database object.

OBJECT_PRIVILEGE

CHAR(20)

One of:
"DATABANK"
"BACKUP"
"SHADOW"
"IDENT"
"MEMBER"
"PROGRAM"
"TABLE"
"DOMAIN"
"MODULE"
"PROCEDURE"
"FUNCTION"
"SCHEMA"
"SEQUENCE"
"CHARACTER SET"
"COLLATION"
"TRANSLATION".

GRANTEE

VARCHAR(128)

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

GRANTOR

VARCHAR(128)

The name of the ident granting the usage 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.

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