SQL Permissions for Table Groups | Dataford Interview Questions

Write SQL statements to grant permissions for each of your tables to a specific group.

Asked in the VO stage. Final VO round SQL question.

Requirements

Write the SQL needed to grant a chosen role access to every existing table in a schema.
Include the statement needed so future tables in that schema also inherit the same permission.
Use PostgreSQL syntax only.

schema_tables

Column	Type	Description
schema_name	VARCHAR(128)	Schema that contains the tables
table_name	VARCHAR(128)	Table name
grantee_role	VARCHAR(128)	Role or group that should receive access
privilege_type	VARCHAR(32)	Requested privilege

Your question is SQL Permissions for Table Groups. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Write SQL statements to grant permissions for each of your tables to a specific group.

Asked in the VO stage. Final VO round SQL question.

Write the SQL needed to grant a chosen role access to every existing table in a schema.
Include the statement needed so future tables in that schema also inherit the same permission.
Use PostgreSQL syntax only.

schema_tables

Column	Type	Description
schema_name	VARCHAR(128)	Schema that contains the tables
table_name	VARCHAR(128)	Table name
grantee_role	VARCHAR(128)	Role or group that should receive access
privilege_type	VARCHAR(32)	Requested privilege

Your question is SQL Permissions for Table Groups. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.