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

The correct answer is D. OWNERSHIP E. CREATE USER. In Snowflake, two privileges enable creating or managing users: OWNERSHIP on the USER object grants full control over that user (including modifying and dropping them), and CREATE USER privilege (typically granted on the account) allows creating new user objects. GRANT is a SQL…

Account Access and Security

Question

Options

AGRANT
BSELECT
CMODIFY
DOWNERSHIP
ECREATE USER

How the community answered

(44 responses)

A
2% (1)
B
2% (1)
C
5% (2)
D
91% (40)

Explanation

In Snowflake, two privileges enable creating or managing users: OWNERSHIP on the USER object grants full control over that user (including modifying and dropping them), and CREATE USER privilege (typically granted on the account) allows creating new user objects. GRANT is a SQL statement, not a privilege type. SELECT is a data access privilege applicable to tables/views, not user management. MODIFY is a privilege for altering certain objects (like warehouses) but is not sufficient on its own to create or manage users. Only OWNERSHIP and CREATE USER are the correct answers for user lifecycle management.

Topics

#User Management#Privileges#Access Control#Security

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice