
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 ...