QuestionQ65

Secure Data Sharing and Consumption

An account contains two databases, fin_db and hr_db, which hold payroll and employee data, respectively. Accountants and Analysts at the company need different permissions on objects in these databases to perform their work. Accountants require read-write access to fin_db, but need only read-only access to hr_db because that database is maintained by human resources personnel.

An Architect must create a read-only role for certain employees in the human resources department.

Which permission sets must be granted to this role?

Explanation

In Snowflake, a role needs USAGE on a database and its schemas to access objects within that hierarchy, and SELECT on tables to read their data. This combination provides read-only access without granting data-modification privileges. Snowflake Access Control Privileges

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!