Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 1043

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

    Correct Answer: D, E

    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
pvskbrodOptions: DE

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: DE

I changed my mind

nexerSnowOptions: AE

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

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.