SQL: Structured Query Language - Oracle 10g Database Administration Concepts and Implementation Made Simple - page 72

CREATE SEQUENCE
CREATE ANY SEQUENCE
ALTER ANY SEQUENCE
DROP ANY SEQUENCE
SELECT ANY SEQUENCE

Sequence

CREATE SYNONYM
CREATE ANY SYNONYM
CREATE PUBLIC SYNONYM
DROP ANY SYNONYM
DROP PUBLIC SYNONYM

Synonym

CREATE SESSION
ALTER SESSION

Session

CREATE TABLESPACE
ALTER TABLESPACE
DROP TABLESPACE
MANAGE TABLESPACE
UNLIMITED TABLESPACE

Tablespace

CREATE USER
ALTER USER
BECOME USER
DROP USER

User

CREATE VIEW
CREATE ANY VIEW
DROP ANY VIEW

View

CREATE ANY INDEX
ALTER ANY INDEX
DROP ANY INDEX

Index

CREATE ROLLBACK
SEGMENT
ALTER ROLLBACK
SEGMENT
DROP ROLLBACK SEGMENT
Figure 2-22: System privileges with corresponding category.

Rollback Segment

Besides these are system privileges for PL/SQL functionalities
like CREATE PROCEDURE, CREATE ANY PROCEDURE,
EXECUTE ANY PROCEDURE etc.