REVOKE DATABASE ROLE¶
Revokes a database role from an account role or another database role.
Tip
You can also use the Snowflake REST APIs to perform this operation. For information, see Revoke grants from the role (REST endpoint reference).
Syntax¶
REVOKE DATABASE ROLE <name> FROM ROLE <parent_role_name>
Parameters¶
nameSpecifies the identifier for the database role to revoke. If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.
ROLE parent_role_nameRevokes the database role from the specified role.
Examples¶
REVOKE DATABASE ROLE analyst FROM ROLE SYSADMIN;