How Functional Privileges and Permissions Work Together

Certain rules determine the behavior of privileges and permissions.

  • A role assigned a functional privilege cannot perform any actions in the catalog until catalog permissions are also assigned

  • A role can be assigned a set of permissions on catalog objects without being assigned any functional privileges

  • If a role is assigned a functional privilege, when catalog permissions are assigned, some permissions are inherited