COF-C02 · Question #307
Which role has the ability to create and manage users and roles?
The correct answer is B. USERADMIN. USERADMIN is the Snowflake system-defined role specifically designed to create and manage users and roles. It holds the CREATE USER and CREATE ROLE system privileges. SECURITYADMIN (which inherits USERADMIN) can also do this but is broader in scope, managing object-level…
Question
Which role has the ability to create and manage users and roles?
Options
- AORGADMIN
- BUSERADMIN
- CSYSADMIN
- DSECURITYADMIN
How the community answered
(35 responses)- A3% (1)
- B89% (31)
- C3% (1)
- D6% (2)
Explanation
USERADMIN is the Snowflake system-defined role specifically designed to create and manage users and roles. It holds the CREATE USER and CREATE ROLE system privileges. SECURITYADMIN (which inherits USERADMIN) can also do this but is broader in scope, managing object-level security grants across the account. SYSADMIN manages databases and warehouses. ORGADMIN manages organization-level settings. The question asks which role has this ability - USERADMIN is the most precise answer as it is the role purpose-built for user and role management.
Topics
Community Discussion
No community discussion yet for this question.