What is the privilege my user requires to be able to grant 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