What is the privilege my user requires to be able to grant the following privileges
CONNECT, RESOURCE and CREATE SESSION
to OTHER users in Oracle 11g?
If a system privilege is granted with ADMIN OPTION to a user, this user can grant this system privileges to other users, e.g. after
GRANT CREATE SESSION TO SCOTT WITH ADMIN OPTION
Scott is able to grant CREATE TABLE to other users. He is also able to grant CREATE TABLE to other users WITH GRANT OPTION. WITH GRANT OPTION works for roles too.
An object privileges (like a select on a table) must be granted WITH GRANT OPTION to a user to grant it to another user.
GRANT SELECT ON HR.EMPLOYEES TO SCOTT WITH GRANT OPTION
This can be found in the SQL Language Reference