Oracle MySQL 5.7 Database Administrator — Question 5

You are contacted by a user who does not have permission to access a database table. You determine after investigation that this user should be permitted to have access and so you execute a GRANT statement to enable the user to access the table.
Which statement describes the activation of that access for the user?

Answer options

• A. The access does not take effect until the user logs out and back in.
• B. The access does not take effect until the next time the server is started.
• C. The access is available immediately.
• D. The access does not take effect until you issue the FLUSH PRIVILEGES statement.

Correct answer: C

Explanation

The correct answer is C because in most database systems, when a GRANT statement is executed, the permissions take effect immediately for the user without requiring any additional actions. Other options are incorrect; A and B suggest delays that are not typical, and D implies an extra step that is unnecessary in this context.