Limit DML but allow SELECT
SQL
Medium
3 views
Problem Description
User data_entry should be able to SELECT and INSERT into Orders but cannot UPDATE or DELETE. Write grants.
Input Format
SQL statements
Output Format
Privileges applied
Official Solution
GRANT SELECT, INSERT ON Orders TO data_entry; REVOKE UPDATE, DELETE ON Orders FROM data_entry;
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!