Download Mimer SQL Reference Manual - Department of Information Technology

Data dictionary views
7-21
EXT_OBJECT_PRIVILEGES
The EXT_OBJECT_PRIVILEGES system view shows which object privileges
that are granted to an authorization ident. Either GRANTEE or GRANTOR
should be equal to current ident.
Column name
Data type
Description
GRANTEE
VARCHAR(128) Name of authorization ident that has received
the privilege.
OBJECT_CATALOG
VARCHAR(128) Catalog name for object.
OBJECT_SCHEMA
VARCHAR(128) Schema name for object.
OBJECT_NAME
VARCHAR(128) Name of object on which privilege is granted.
OBJECT_TYPE
VARCHAR(20)
One of:
“CHARACTER SET”
“DOMAIN”
“DATABANK”
“FUNCTION”
“IDENT”
“PROCEDURE”
“SEQUENCE”.
PRIVILEGE_TYPE
VARCHAR(20)
One of:
“EXECUTE”
“FUNCTION”
“MEMBER”
“PROCEDURE”
“TABLE”
“USAGE”.
GRANTOR
VARCHAR(128) Name of authorization ident that granted the
privilege.
IS_GRANTABLE
VARCHAR(3)
One of:
“YES” = the grantee may grant the privilege
“NO” = the grantee may not grant the privilege.
Mimer SQL version 8.2
Reference Manual