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