|Lesson7||The WITH ADMIN OPTION|
|Objective||Allow users to administer role.|
WITH GRANT OPTION, allowing the user to re-grant the privilege to others.
WITH GRANT OPTIONwith a role, authorizing the same function as with a privilege grant. You can also use
the WITH ADMIN OPTIONfor a role. This gives the user the ability to not only re-grant the role, but to perform administrative functions for the role, such as altering the role or dropping the role.
WITH ADMIN OPTIONis an extremely powerful facility. Because the normal use of roles is to simplify administration of an entire security scheme, giving someone the ability to change the rights granted by a role should be done only with great care.