TABLEPRIVILEGES

Definition

The system table TABLEPRIVILEGES describes the privileges that the current user has for tables.

Structure

TABLEPRIVILEGES

SCHEMANAME

CHAR(32)

Name of the schema of the table

OWNER

CHAR(32)

Name of the owner of the table

TABLENAME

CHAR(32)

Name of the table

GRANTOR

CHAR(32)

Name of the user who granted the privileges

GRANTEE

CHAR(32)

Name of the user or role to which an assignment was made

PRIVILEGES

CHAR(30)

Granted privileges

IS_GRANTABLE

CHAR(3)

Privilege to grant the received privilege to another user/role (YES | NO)

See also:

Evaluating System Tables, TABLEPRIVILEGES

SQL Reference Manual, Privileges: Overview