Grant SELECT on a single table
SQL
Easy
2 views
Problem Description
Create a user analyst and grant only SELECT on Orders table.
Input Format
SQL statements
Output Format
Privileges applied
Sample Test Case
Input:
Orders table exists
Constraints
Assume you have admin rights
Official Solution
CREATE USER analyst IDENTIFIED BY 'StrongPass123'; GRANT SELECT ON Orders TO analyst;
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!