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