SQL practice: Roles and Permissions: GRANT and REVOKE
Chapter 31B · 4 questions · included in full access
Question 1 · easy
Solve it in your browserCreate a new database role named junior_analyst.
Question 2 · easy
Solve it in your browserGrant SELECT and INSERT privileges on the customers table to junior_analyst.
Question 3 · hard
Solve it in your browserQuery information_schema.role_table_grants to inspect which privileges junior_analyst holds on customers. Return table_name and privilege_type ordered by privilege_type.
Question 4 · hard
Solve it in your browserRevoke the INSERT privilege on customers from junior_analyst, leaving only read access.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing