System DBA Clause | Password Management and Connectivity
How to Grant System Privileges
As with object privileges, you use the GRANT statement to confer system privileges on either
a user or a role. Unlike object privileges, the optional keywords WITH ADMIN OPTION are required to additionally allow the grantee to confer these privileges on other users and roles. For example, to give the CREATE USER, ALTER USER, and DROP USER privileges to the role APPL_DBA, you execute the following statement:
GRANT create user, alter user,
drop user TO appl_dba;
System and role privileges require the wording WITH ADMIN OPTION;
object privileges require the wording WITH GRANT OPTION.
Because the function is so similar but the syntax is different, be sure you know when to use ADMIN
and when to use GRANT—a question involving this subtle difference may appear on the exam.