Bird
0
0

Consider this SQL command:

medium📝 query result Q13 of 15
SQL - Security Basics
Consider this SQL command:
REVOKE UPDATE ON employees FROM user_john;
What is the effect of this command?
AUser John is granted update permission on employees
BUser John can update the employees table
CUser John is deleted from the database
DUser John can no longer update the employees table
Step-by-Step Solution
Solution:

  1. Step 1: Understand the REVOKE command

    REVOKE removes permissions previously given to a user.

  2. Step 2: Apply to the given command

    This command removes the UPDATE permission on the employees table from user_john.

  3. Final Answer:

    User John can no longer update the employees table -> Option D

  4. Quick Check:

    REVOKE UPDATE = remove update rights [OK]
Quick Trick: REVOKE removes permission, so user loses update rights [OK]
Common Mistakes:
  • Thinking REVOKE grants permission
  • Confusing REVOKE with DELETE user
  • Assuming REVOKE affects all permissions

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes
Advanced Query Patterns - Top-N per group query - Quiz 7medium CASE Expressions - COALESCE and NULLIF as CASE shortcuts - Quiz 3easy Common Table Expressions (CTEs) - Recursive CTE for hierarchical data - Quiz 8hard Database Design and Normalization - Star schema concept - Quiz 5medium SQL Security Basics - Why prepared statements exist - Quiz 1easy Stored Procedures and Functions - Parameters (IN, OUT, INOUT) - Quiz 4medium Triggers - Trigger performance considerations - Quiz 6medium Triggers - Why triggers are needed - Quiz 14medium Triggers - INSERT trigger - Quiz 12easy Window Functions Fundamentals - Window function vs GROUP BY mental model - Quiz 9hard