REVOKE DATABASE ROLE¶

Revokes a database role from an account role or another database role.

See also:

GRANT DATABASE ROLE , GRANT ROLE , REVOKE ROLE , GRANT <privileges> … TO ROLE

语法

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

REVOKE DATABASE ROLE <name> FROM APPLICATION <app_name>

参数

name

指定要撤消的数据库角色的标识符。如果标识符包含空格或特殊字符，则整个字符串必须放在双引号内。放在双引号内的标识符也区分大小写。

DATABASE ROLE parent_role_name

从指定的数据库角色中撤销数据库角色。

ROLE parent_role_name

从指定的账户角色中撤销数据库角色。

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;