SHOW DEFAULT PRIVILEGES
SHOW DEFAULT PRIVILEGES lists the default privileges granted on objects in Materialize.
Syntax
| Field | Use |
|---|---|
| object_name | Only shows default privileges for a specific object type. |
| role_name | Only shows default privileges granted directly or indirectly to role_name. |
Examples
SHOW DEFAULT PRIVILEGES;
object_owner | database | schema | object_type | grantee | privilege_type
--------------+----------+--------+-------------+---------+----------------
PUBLIC | | | cluster | interns | USAGE
PUBLIC | | | schema | mike | CREATE
PUBLIC | | | type | PUBLIC | USAGE
mike | | | table | joe | SELECT
SHOW DEFAULT PRIVILEGES ON SCHEMAS;
object_owner | database | schema | object_type | grantee | privilege_type
--------------+----------+--------+-------------+---------+----------------
PUBLIC | | | schema | mike | CREATE
SHOW DEFAULT PRIVILEGES FOR joe;
object_owner | database | schema | object_type | grantee | privilege_type
--------------+----------+--------+-------------+---------+----------------
PUBLIC | | | cluster | interns | USAGE
PUBLIC | | | type | PUBLIC | USAGE
mike | | | table | joe | SELECT