Skip to Main Content
Oracle DBA Pocket Guide
book

Oracle DBA Pocket Guide

by David C. Kreines
August 2005
Intermediate to advanced content levelIntermediate to advanced
154 pages
4h 48m
English
O'Reilly Media, Inc.
Content preview from Oracle DBA Pocket Guide
80
|
Oracle DBA Pocket Guide
Security
Oracle provides a variety of features that can help secure
your database from unauthorized access and can help pro-
tect your data from being seen or manipulated by unau-
thorized users. This section provides information on Oracle’s
major security features: authentication, profiles, privileges,
roles, and auditing.
Authentication
Authentication is the process of identifying and recognizing
authorized users of the database. Oracle security is primarily
based on the concept of individual authorized users, so
authentication is a critical component.
Two system users are created when you install Oracle:
SYS
The schema for SYS contains the base tables and views
used for the data dictionary. You should never change
any of these tables. The SYS user has the DBA role.
(Roles are described in the “Roles” section later in this
book.) The default password for SYS is CHANGE_ON_
INSTALL.
SYSTEM
The SYSTEM username is used to create additional
tables and views for administrative information. The
SYSTEM user has the DBA role. The default password
for SYSTEM is MANAGER.
When you create an Oracle database using the CREATE
DATABASE statement, you can use the USER SYS IDENTI-
FIED BY password and USER SYSTEM IDENTIFIED BY pass-
word clauses to protect access by these powerful pre-created
users.
Security
|
81
In addition to SYS and SYSTEM, users can be created with
the CREATE USER command. User ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle RMAN Pocket Reference

Oracle RMAN Pocket Reference

Darl Kuhn, Scott Schulze

Publisher Resources

ISBN: 9780596528843