SYS_ROUTINE_PRIVILEGES

Information on parameters for routines (procedures and UDFs)

Column name

Data type

Contents

GRANTEE

CHAR(18)

Authorization identifier granted the
privilege or

PUBLIC

SPECIFIC_SCHEMA

CHAR(31)

Name of the schema to which the
routine belongs

SPECIFIC_NAME

CHAR(31)

Specific name of the routine

GRANTOR

CHAR(18)

Authorization identifier which granted
the privilege or

_SYSTEM

IS_GRANTABLE

VARCHAR(3)

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

Table 126: SYS_ROUTINE_PRIVILEGES view of the SYS_INFO_SCHEMA