Which statement correctly grants SELECT permission on one database to a user?
- A GRANT SELECT ON db.* TO 'user'@'host'
- B ALLOW SELECT ON db TO user
- C PERMIT SELECT ON db.* FOR user
- 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.





