SnowPro Associate Platform SOL-C01

By Snowflake · Question Mode

QuestionQ101

Understand Snowflake roles, and data access management

Which SQL command removes a role from a user in Snowflake without deleting that role from the account?

Explanation

REVOKE ROLE removes a role granted to a specified user while leaving the role defined in the account. Its syntax includes REVOKE ROLE <name> FROM USER <user_name>.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!