Back to Materialize

Show Default Privileges New Roles

doc/user/content/headless/rbac-cloud/show-default-privileges-new-roles.md

123713 B
Original Source
none
| object_owner | database | schema | object_type | grantee | privilege_type |
| ------------ | -------- | ------ | ----------- | ------- | -------------- |
| PUBLIC       | null     | null   | type        | PUBLIC  | USAGE          |

The example results show one default privilege. This default privilege grants USAGE privilege to all users (grantee PUBLIC) for new types created by any user (object_owner PUBLIC).

{{< note >}}

  • To use a type created in a schema, the USAGE access is required on the containing schema as well.
  • {{% include-headless "/headless/rbac-cloud/default-privilege-clarification" %}}

{{</ note >}}