ROLEPRIVILEGES

Definition

The system table ROLEPRIVILEGES describes the privileges and roles that have been granted to roles for which the current user has privileges.

Structure

ROLEPRIVILEGES

SCHEMANAME

CHAR(32)

Name of the schema of the object that was granted to the role

OWNER

CHAR(32)

Name of the owner of the object that was granted to the role

TABLENAME

CHAR(32)

Name of the table for which privileges were granted to the role

ROLE

CHAR(32)

Name of the granted role

GRANTEE

CHAR(32)

Name of the role to which an assignment was made

PRIVILEGES

CHAR(30)

Granted privileges

GRANTOR

CHAR(32)

Name of the user who granted the privileges or role

CREATEDATE

DATE(10)

Date on which the privilege was granted

CREATETIME

TIME(8)

Time at which the privilege was granted

See also:

Evaluating System Tables, ROLEPRIVILEGES

SQL Reference Manual, Role Name (role_name), Privileges: Overview