table_privileges
The view table_privileges
identifies all
privileges granted on tables or views to a currently enabled role
or by a currently enabled role. There is one row for each
combination of table, grantor, and grantee.
Table 39.51. table_privileges
Columns
Column Type Description |
---|
Name of the role that granted the privilege |
Name of the role that the privilege was granted to |
Name of the database that contains the table (always the current database) |
Name of the schema that contains the table |
Name of the table |
Type of the privilege: |
|
In the SQL standard, |