Oracle Database Administration: The Essential Refe

Privileges That Affect the Entire Database

Table 15.3 lists the privileges that are traditionally reserved to the database administrator and that have been granted to the DBA role. These privileges allow DBAs to alter the database, create new users, define public database links and synonyms, and grant any privilege or role without having first been granted the role with the WITH ADMIN OPTION option (see Chapter 13, for information about specifying that option).

Table 15-3. Privileges That Affect the Entire Database

ALTER DATABASE	ALTER PROFILE
ALTER RESOURCE COST	ALTER ROLLBACK SEGMENT
ALTER SYSTEM	ALTER TABLESPACE
ALTER USER	AUDIT SYSTEM
BECOME USER	CREATE LIBRARY
CREATE PROFILE	CREATE PUBLIC DATABASE LINK
CREATE PUBLIC SYNONYM	CREATE ROLE
CREATE ROLLBACK SEGMENT	CREATE TABLESPACE
CREATE USER	DROP PROFILE
DROP PUBLIC DATABASE LINK	DROP PUBLIC SYNONYM
DROP ROLLBACK SEGMENT	DROP TABLESPACE
DROP USER	GRANT ANY PRIVILEGE
GRANT ANY ROLE	MANAGE TABLESPACE
RESTRICTED SESSION	UNLIMITED TABLESPACE