Remove all privileges safely

SQL Hard 3 views
Back to Questions
Previous Audit-friendly approach for sensitive tables Hard P Next Least privilege for stored procedures Hard N

Problem Description

You are deactivating contractor_user. Revoke all granted permissions first, then lock/disable the account (write generic SQL steps).

Input Format

SQL statements

Output Format

Account restricted

Sample Test Case

Input:
User exists
Output:
User blocked

Constraints

Exact syntax varies by database
Please login to submit solutions and comments.

Solutions (0)

No solutions submitted yet. Be the first!

Discussion (0)

No comments yet. Start the discussion!

Prev Next