System-defined roles (ACCOUNTADMIN, SYSADMIN, etc.) in Snowflake - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to switch to the SYSADMIN role.

Snowflake

USE ROLE [1];

Drag options to blanks, or click blank then click option'

ASYSADMIN

BSECURITYADMIN

CPUBLIC

DACCOUNTADMIN

Attempts:

3 left

💡 Hint

Common Mistakes

Using ACCOUNTADMIN instead of SYSADMIN.

Typing role names in lowercase.

The USE ROLE command switches your current role. To switch to the SYSADMIN role, use USE ROLE SYSADMIN;.

2fill in blank

medium

Complete the code to grant the SECURITYADMIN role to a user.

Snowflake

GRANT ROLE [1] TO USER alice;

Drag options to blanks, or click blank then click option'

ASYSADMIN

BSECURITYADMIN

CACCOUNTADMIN

DPUBLIC

Attempts:

3 left

💡 Hint

Common Mistakes

Granting SYSADMIN instead of SECURITYADMIN.

Forgetting to specify the user.

The GRANT ROLE command assigns a role to a user. To give the SECURITYADMIN role to user alice, use GRANT ROLE SECURITYADMIN TO USER alice;.

3fill in blank

hard

Fix the error in the command to switch to the ACCOUNTADMIN role.

Snowflake

USE ROLE [1];

Drag options to blanks, or click blank then click option'

AACCOUNTADMIN

Baccountadmin

CAccountAdmin

DADMIN

Attempts:

3 left

💡 Hint

Common Mistakes

Using lowercase or mixed case role names.

Using a non-existent role like ADMIN.

Role names are case-sensitive and must be uppercase. The correct role name is ACCOUNTADMIN.

4fill in blank

hard

Fill both blanks to create a role hierarchy where SYSADMIN is granted to ACCOUNTADMIN.

Snowflake

GRANT ROLE [1] TO ROLE [2];

Drag options to blanks, or click blank then click option'

ASYSADMIN

BPUBLIC

CACCOUNTADMIN

DSECURITYADMIN

Attempts:

3 left

💡 Hint

Common Mistakes

Reversing the roles in the grant statement.

Using PUBLIC or SECURITYADMIN incorrectly.

To grant SYSADMIN role to ACCOUNTADMIN role, use GRANT ROLE SYSADMIN TO ROLE ACCOUNTADMIN;.

5fill in blank

hard

Fill both blanks to revoke the SECURITYADMIN role from user bob.

Snowflake

REVOKE ROLE [1] FROM USER [2];

Drag options to blanks, or click blank then click option'

ASYSADMIN

Bbob

CSECURITYADMIN

Dalice

Attempts:

3 left

💡 Hint

Common Mistakes

Revoking the wrong role.

Using the wrong user name.

To remove the SECURITYADMIN role from user bob, use REVOKE ROLE SECURITYADMIN FROM USER bob;.