Oracle Maestro online help
Prev | Return to chapter overview | Next |
Specifying profile properties
![](/i/tour-under-title.gif)
The wizard step was supplied to define common user profile properties. The detailed description of the properties you can find below.
Name
The field contains the editable new user profile name as it was set on the previous wizard step.
Composite limit
Specify the total resource cost for a session, expressed in service units. Oracle Database calculates the total service units as a weighted sum of CPU per session, Connect time, Logical reads per session, and Private SGA.
Password grace time (days)
Specify the number of days after the grace period begins during which a warning is issued and login is allowed. If the password is not changed during the grace period, the password expires.
Password lock time (days)
Specify the number of days an account will be locked after the specified number of consecutive failed login attempts.
Password verify function
The clause lets a PL/SQL password complexity verification script be passed as an argument to the CREATE PROFILE statement. Oracle Database provides a default script, but you can create your own routine or use third-party software instead.
Password reuse max
The clause specifies the number of password changes required before the current password can be reused. For these parameter to have any effect, you must specify an integer for both of them.
Password reuse time (days)
The option specifies the number of days before which a password cannot be reused.
Password life time (days)
Specify the number of days the same password can be used for authentication. If you also set a value for Password grace time, the password expires if it is not changed within the grace period, and further connections are rejected. If you do not set a value for Password grace time, its default of Unlimited will cause the database to issue a warning but let the user continue to connect indefinitely.
Failed login attempts
Specify the number of failed attempts to log in to the user account before the account is locked.
Private SGA (Bytes)
Specify the amount of private space a session can allocate in the shared pool of the system global area (SGA), expressed in bytes.
Connect time (min)
Specify the total elapsed time limit for a session, expressed in minutes.
Idle time (min)
Specify the permitted periods of continuous inactive time during a session, expressed in minutes. Long-running queries and other operations are not subject to this limit.
Logical reads per call
Specify the permitted the number of data blocks read for a call to process a SQL statement (a parse, execute, or fetch).
Logical reads per session
Specify the permitted number of data blocks read in a session, including blocks read from memory and disk.
CPU per session (0.01 sec)
Specify the CPU time limit for a session, expressed in hundredth of seconds.
CPU per call (0.01 sec)
Specify the CPU time limit for a call (a parse, execute, or fetch), expressed in hundredths of seconds.
Sessions per user
Specify the number of concurrent sessions to which you want to limit the user.
Prev | Return to chapter overview | Next |