Grant column-level access (hard)

Grant column-level access (hard)

Hard SQL DCL 12 views
Explanation Complexity

Problem Statement

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

Example

Customers(customer_id, name, email, phone)
Limited access

Constraints

Column-level grants depend on DB

Input / Output Format

Input Format
SQL statements
Output Format
Privileges applied
Constraints
Column-level grants depend on DB

Examples

Input:
Customers(customer_id, name, email, phone)
Output:
Limited access

Example Solution (Public)

SQL 
GRANT SELECT (customer_id, name) ON Customers TO support_viewer;

Official Solution Code

GRANT SELECT (customer_id, name) ON Customers TO support_viewer;
Please login to submit solutions.
Editor
Output

                                        

                                    

                                    

                                        

                                                                                    
Please login to submit solutions.