Which of the following commands lists all the privileges granted to a user?
A)SHOW GRANTS
B)SHOW PRIVILEGES
C)SHOW USERS
D)SHOW SECURITY

Question

Quizplus · Accepted Answer

The command "SHOW GRANTS" lists all the privileges granted to a user. The other options do not provide the same information. "SHOW PRIVILEGES" would list the available privileges, but not the ones granted to a specific user. "SHOW USERS" lists all the users on the system, but not their specific privileges. "SHOW SECURITY" is not a valid MySQL command.

Which of the Following Commands Lists All the Privileges Granted