Here the answer should be SECURITYADMIN as it is parent of USERADMIN (which is the correct answer)
More details: https://docs.snowflake.com/en/user-guide/security-access-control-considerations
Attention
By default, when your account is provisioned, the first user is assigned the ACCOUNTADMIN role. This user should then create one or more additional users who are assigned the USERADMIN role. All remaining users should be created by the user(s) with the USERADMIN role or another role that is granted the global CREATE USER privilege.
ORGADMIN manages operations at the organizational level
ACCOUNTADMIN performs administrative functions
SECURITYADMIN creates and manages users and roles, and manages grants
USERADMIN creates users and roles
SYSADMIN creates and manages databases, schemas, and warehouses
PUBLIC is available to all users, but (by default) cannot do anything but log in
TYPES OF ROLES:
SYSTEM ROLES:
● ORGADMIN manages operations at the organizational level
● ACCOUNTADMIN performs administrative functions
● SECURITYADMIN creates and manages users and roles, and manages grants
● USERADMIN creates users and roles
● SYSADMIN creates and manages databases, schemas, and warehouses
● PUBLIC is available to all users, but (by default) cannot do anything but log in
CUSTOM ROLES:
● Created by the SECURITYADMIN or USERADMIN based on a company's desired hierarchy
● Custom roles generally "roll up" to the SYSADMIN role
B. SECURITYADMIN
The SECURITYADMIN role is specifically designed to handle security-related tasks, including the creation and management of users and roles. This role has the necessary privileges to manage all aspects of user and role administration, which is essential for maintaining a secure and well-managed Snowflake environment.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
blazingliverbird
Highly Voted 3 years, 3 months agoc0d3g
Highly Voted 2 years, 2 months agodbairfan
Most Recent 2 weeks, 1 day agoYayi123
3 weeks, 5 days agoPrasantSadangi
1 month agotharangaweer
2 months, 4 weeks agohotflake
8 months, 4 weeks agoMallikharjuna452
9 months, 2 weeks agopranalig
10 months, 2 weeks agoPrashantGupta1616
10 months, 4 weeks agoJasMozai
11 months, 4 weeks agoAnireddySaikiranReddy
1 year, 2 months ago_yyukta
1 year, 2 months agoengo
1 year, 2 months agoKritig08
1 year, 3 months agoSuman_Mondal
1 year, 4 months agoKHarish
1 year, 4 months ago