Privilege_hierarchies.htm
An Ascending list of Privileges:

ADMIN [ALL privileges,  also admin cache manager]
CREATE ANY INDEX
CREATE ANY MATERIALIZED VIEW
CREATE ANY PROCEDURE
CREATE ANY SEQUENCE
CREATE ANY SYNONYM
CREATE ANY TABLE
CREATE ANY VIEW
DELETE ANY TABLE
EXECUTE ANY PROCEDURE
INSERT ANY TABLE
SELECT ANY SEQUENCE
SELECT ANY TABLE
UPDATE ANY TABLE
 

CACHE_MANAGER Privileges:


CREATE ANY CACHE GROUP
ALTER ANY CACHE GROUP
DROP ANY CACHE GROUP
FLUSH ANY CACHE GROUP
LOAD ANY CACHE GROUP
UNLOAD ANY CACHE GROUP
REFRESH ANY CACHE GROUP
FLUSH (object)
LOAD (object)
UNLOAD (object)
REFRESH (object)