ROLE_SYS_PRIVS

2023-12-08 07:13:36  Updated

Purpose

The ROLE_SYS_PRIVS view displays system privileges granted to roles.

Applicability

This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.

Columns

Column Type Nullable? Description
ROLE VARCHAR2(128) NO The name of the role.
PRIVILEGE VARCHAR2(40) NO The system privilege granted to the role.
ADMIN_OPTION VARCHAR2(3) NO Indicates whether the role was granted with the ADMIN option.

Contact Us