SnowPro Advanced Administrator ADA-C02

By Snowflake · Question Mode

QuestionQ14

Manage and administer Snowflake accounts, data security, and governance

A Snowflake account uses SCIM provisioning for user accounts and has bidirectional synchronization of user identities. An Administrator with access to SECURITYADMIN creates a user in the Snowflake UI by issuing these commands:

Question Image

The new user, PTORRES, logs in successfully but sees PUBLIC as the default role in the web UI. The following command fails when attempted:

USE DEVELOPER_ROLE;

Why does this command fail?

Explanation

Setting DEFAULT_ROLE does not grant that role to a user. DEVELOPER_ROLE must be explicitly granted to PTORRES before the user can activate it with USE DEVELOPER_ROLE; otherwise, the user has only the automatically available PUBLIC role.

Learn more

Community Discussion

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