Managing roles in RBAC
To perform the following actions, use the following commands:
-
To create a role, use the CREATE ROLE command.
-
To rename a role or change the owner of the role, use the ALTER ROLE command.
-
To delete a role, use the DROP ROLE command.
-
To grant a role to a user, use the GRANT command.
-
To revoke a role from a user, use the REVOKE command.
-
To grant system permissions to a role, use the GRANT command.
-
To revoke system permissions from a role, use the REVOKE command.
To view a list of roles in your cluster or workgroup, see SVV_ROLES.