ROUTINE_PRIVILEGES

Information on the privileges for routines (procedures and UDFs) which the current authorization identifier has or which it has granted.

Column name

Data type

Contents

GRANTOR

CHAR(18)

Authorization identifier which granted
the privilege or

_SYSTEM

GRANTEE

CHAR(18)

Authorization identifier

granted the privilege or

PUBLIC

SPECIFIC_CATALOG

CHAR(18)

Database name

SPECIFIC_SCHEMA

CHAR(31)

Name of the schema to which the
routine belongs

SPECIFIC_NAME

CHAR(31)

Specific name of the routine

ROUTINE_CATALOG

CHAR(18)

Database name

ROUTINE_SCHEMA

CHAR(31)

Name of the schema to which the
routine belongs

ROUTINE_NAME

CHAR(31)

Name of the routine.

PRIVILEGE_TYPE

CHAR(18)

EXECUTE

IS_GRANTABLE

VARCHAR(3)

YES	The authorization identifier has GRANT authorization for the privilege
NO	No GRANT authorization

Table 85: ROUTINE_PRIVILEGES view of the INFORMATION_SCHEMA