Grant column-level access (hard)
SQL
Hard
3 views
Problem Description
You want user support_viewer to see only customer_id and name from Customers, not email/phone. Grant SELECT on only these columns (column-level privilege).
Input Format
SQL statements
Output Format
Privileges applied
Sample Test Case
Input:
Customers(customer_id, name, email, phone)
Constraints
Column-level grants depend on DB
Official Solution
GRANT SELECT (customer_id, name) ON Customers TO support_viewer;
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!