REVOKE DATABASE ROLE¶

See also:: GRANT DATABASE ROLE , GRANT ROLE , REVOKE ROLE , GRANT <privileges> … TO ROLE

Syntax¶

REVOKE DATABASE ROLE <name> FROM { ROLE | DATABASE ROLE } <parent_role_name>

REVOKE DATABASE ROLE <name> FROM APPLICATION <app_name>

name: Specifies 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.
DATABASE ROLE parent_role_name: Revokes the database role from the specified database role.
ROLE parent_role_name: Revokes the database role from the specified account role.
APPLICATION app_name: Revokes the database role from the specified Snowflake Native App.

Revokes the database role named analyst from the account role named SYSADMIN.

REVOKE DATABASE ROLE analyst FROM ROLE SYSADMIN;

Revokes the database role named dr1 from another database role named dr2.

REVOKE DATABASE ROLE dr1 FROM DATABASE ROLE dr2;

Revokes the database role named dr1 from the Snowflake Native App named hello_snowflake_app.

REVOKE DATABASE ROLE dr1 FROM APPLICATION hello_snowflake_app;