Object documentationTABLEPRIVILEGES Locate this document in the navigation structure

 

The system table DOMAIN.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

PRIVILEGE

CHAR(30)

Granted privileges

IS_GRANTABLE

CHAR(3)

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

More Information

Evaluating System Tables, TABLEPRIVILEGES

SQL Reference Manual, Privileges: Overview