SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 1043


A user with which privileges can create or manage other users in a Snowflake account? (Choose two.)

Show Answer
Correct Answer: DE

To create or manage users in a Snowflake account, a user needs the CREATE USER privilege to actually create users. Additionally, to manage other user accounts, the user must have the OWNERSHIP privilege on those accounts, allowing them to modify user properties. Users with these privileges can effectively perform the necessary administrative tasks related to user management.

Discussion

4 comments
Sign in to comment
pvskbrodOptions: DE
Sep 22, 2024

D& E Create users The USERADMIN system role can create users using SQL (CREATE USER). If you prefer to use a custom role for this purpose, grant the CREATE USER privilege on the account to this role. Modify users Only the role with the OWNERSHIP privilege on a user, or a higher role, can modify most user properties using SQL (ALTER USER). In addition, the role must have the global CREATE USER privilege. https://docs.snowflake.com/en/user-guide/admin-user-management

nexerSnowOptions: AE
Sep 10, 2024

Create users: The USERADMIN system role can create users using SQL (CREATE USER). If you prefer to use a custom role for this purpose, grant the CREATE USER privilege on the account to this role. https://docs.snowflake.com/en/user-guide/admin-user-management

mickies9
Nov 8, 2024

As per the link you have shared, correct answer should be D and E Privileges required to create and modify users The following roles or privileges are required to manage users in your account: Create users The USERADMIN system role can create users using SQL (CREATE USER). If you prefer to use a custom role for this purpose, grant the CREATE USER privilege on the account to this role. Modify users Only the role with the OWNERSHIP privilege on a user, or a higher role, can modify most user properties using SQL (ALTER USER). In addition, the role must have the global CREATE USER privilege.

nexerSnowOptions: DE
Nov 9, 2024

I changed my mind

MatthieuDNOptions: DE
Jan 24, 2025

DE is correct