Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

Which statement correctly grants SELECT permission on one database to a user?

  1. A GRANT SELECT ON db.* TO 'user'@'host'
  2. B ALLOW SELECT ON db TO user
  3. C PERMIT SELECT ON db.* FOR user
  4. D SET SELECT ON db TO user
Answer

GRANT SELECT ON db.* TO 'user'@'host'

GRANT assigns privileges at global, database, table or column level. Applying least privilege means granting only the specific rights the application needs.

All MySQL MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as