1Z0-908: MySQL 8.0 Database AdministratorDemo

Question

Examine the following SQL statement:

mysql&gt; GRANT r_read@localhost TO mark WITH ADMIN OPTION;

Which two statements are true?

Choose two

A Mark can grant the privileges assigned to the r_read@localhost role to another user.
B ADMIN OPTION causes the role to be activated by default.
C Mark can grant the r_read@localhost role to another user.
D Mark can revoke the r_read@localhost role from another role.
E ADMIN OPTION allows Mark to drop the role.
F Mark must connect from localhost to activate the r_read@localhost role.

Explanation

WITH ADMIN OPTION on a role grant authorizes the recipient to grant that specific role to other users or roles and to revoke that role from other users or roles, as long as the role is active when the operation is performed. Role activation is separate from the administrative option, and dropping a role requires different privileges.

Learn more

MySQL 9.1 Reference Manual — GRANT Statement

1Z0-908: MySQL 8.0 Database AdministratorDemo

AstroTutor

Notes

Readiness

QuestionQ40

Community Discussion