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
84
|
Oracle DBA Pocket Guide
Profiles
A profile can be associated with a user to control the
resources available to that user or to specify a condition on
how passwords are administered. By limiting the computing
resources that an individual can use, the DBA can prevent
any single user from exhausting resources and affecting other
users. By placing limits on how passwords are administered,
the DBA can help to safeguard the authentication process for
the Oracle database.
In order to use profiles, the DBA must enable dynamic
resource limits with either the RESOURCE_LIMIT initializa-
tion parameter or the ALTER SYSTEM SET command. Com-
mands related to profiles are described below.
CREATE PROFILE
Allows the DBA to create a profile and assign different types of
resource limits to the profile.
CREATE PROFILE profile_name LIMIT
{resource_parameter | password_parameter}
The following values can be used for both resource and password
parameters, unless specified otherwise in the descriptions:
UNLIMITED
Specifies no limit for the particular parameter.
DEFAULT
Specifies that the parameter assumes the value specified for
the DEFAULT profile. Initially, all values for the DEFAULT
profile are specified as UNLIMITED. You can change the
values for the DEFAULT profile with the ALTER PROFILE
command.
resource_parameter | password_parameter
For resource parameters, the value is an integer. For pass-
word parameters, the value ...
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