ROLES

Definition

The system table ROLES describes the roles for which the current user has privileges.

Structure

ROLES

OWNER

CHAR(32)

Name of the owner of the role

ROLE

CHAR(32)

Name of the role

PASSWORD_REQUIRED

CHAR(3)

Password required for activating role (YES | NO)

GRANTED

CHAR(3)

Role was granted to current user (YES | NO)

DEFAULTROLE

CHAR(3)

Role is the default role for the current user (YES | NO)

CREATEDATE

DATE(10)

Creation date of the role

CREATETIME

TIME(8)

Creation time of the role

See also:

Evaluating System Tables, ROLES

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