Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


ROUTINE_PRIVILEGES


The ROUTINE_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 a routine.

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.
SPECIFIC_CATALOG
VARCHAR(128)
The catalog name for the specific name of the routine.
SPECIFIC_SCHEMA
VARCHAR(128)
The schema name for the specific name of the routine.
SPECIFIC_NAME
VARCHAR(128)
The specific name of the routine.
ROUTINE_CATALOG
VARCHAR(128)
The name of the catalog containing the routine.
ROUTINE_SCHEMA
VARCHAR(128)
The name of the schema containing the routine.
ROUTINE_NAME
VARCHAR(128)
The name of the routine.
PRIVILEGE_TYPE
VARCHAR(128)
The type of the privilege.
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.



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