Which object type is granted permissions for reading a table?

The correct answer is B. Role. In Snowflake, permissions for accessing database objects, including tables, are not granted directly to users but rather to roles. A role encapsulates a collection of privileges on various Snowflake objects. Users are then granted roles, and through those roles, they inherit…

Account Access and Security

Question

Options

AUser
BRole
CAttribute
DSchema

How the community answered

(55 responses)

A
4% (2)
B
95% (52)
D
2% (1)

Explanation

In Snowflake, permissions for accessing database objects, including tables, are not granted directly to users but rather to roles. A role encapsulates a collection of privileges on various Snowflake objects. Users are then granted roles, and through those roles, they inherit the permissions necessary to read a table or perform other actions. This approach adheres to the principle of least privilege, allowing for granular control over database access and simplifying the management of user permissions.

Topics

#Role-based access control#Permissions#Grants#Security model

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice