Usually the DBA is the only person who can grant system privileges.
However, if you trust a user enough, you can allow them to administer one or more system privileges on their own.
To grant a privilege to a user, and allow that user to further grant the privilege to other users, add the
WITH ADMIN OPTION
clause to the end of your
GRANT
command.
For example:
GRANT CREATE USER, CREATE SESSION TO
jeff WITH ADMIN OPTION;
Jeff can now create users on his own, and allow them to connect to the database. Jeff may also pass the admin option on to those users. Roll
your cursor over the following MouseOver to see pop-up explanations of this process.