nerdexam
Snowflake

ADA-C01 · Question #70

Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?

The correct answer is B. Manage system grants. The SECURITYADMIN role is responsible for managing all grants on objects in the account, including system grants. The USERADMIN role can only create and manage users and roles, but not grant privileges on other objects. Therefore, the function that is unique to the…

Account Management and Security

Question

Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?

Options

  • AReset a Snowflake user's password
  • BManage system grants
  • CCreate new users
  • DCreate new roles

How the community answered

(23 responses)
  • A
    4% (1)
  • B
    83% (19)
  • C
    9% (2)
  • D
    4% (1)

Explanation

The SECURITYADMIN role is responsible for managing all grants on objects in the account, including system grants. The USERADMIN role can only create and manage users and roles, but not grant privileges on other objects. Therefore, the function that is unique to the SECURITYADMIN role is to manage system grants.

Topics

#SECURITYADMIN#USERADMIN#system grants#role comparison

Community Discussion

No community discussion yet for this question.

Full ADA-C01 Practice