Online Documentation for SQL Manager for Oracle

Creating/editing profile

Use the Profile tab of Profile Editor to create/edit a profile and specify its properties.

 

Name

Specify the name of the profile to be created, or view the name of the profile being edited.

 

 

Specify resource and password parameters using the corresponding groups.

 

Select DEFAULT from the drop-down list if you want to omit a limit for this resource in this profile. A user assigned this profile is subject to the limit for this resource specified in the DEFAULT profile.

When specified with a resource parameter, UNLIMITED indicates that a user assigned this profile can use an unlimited amount of this resource. When specified with a password parameter, UNLIMITED indicates that no limit has been set for the parameter.

 

Resource parameters

 

Sessions per user

Specify the number of concurrent sessions to which you want to limit the user, or select DEFAULT or UNLIMITED from the drop-down list.

 

CPU per session

Specify the CPU time limit (in milliseconds) for a session, or select DEFAULT or UNLIMITED from the drop-down list. For your convenience the Time calculator is implemented: click the arrow-down button to call the Time calculator popup window.

 

CPU per call

Specify the CPU time limit (in milliseconds) for a call (a parse, execute, or fetch), or select DEFAULT or UNLIMITED from the drop-down list. For your convenience the Time calculator is implemented: click the arrow-down button to call the Time calculator popup window.

 

Connect time

Specify the total elapsed time limit (in minutes) for a session, or select DEFAULT or UNLIMITED from the drop-down list. For your convenience the Time calculator is implemented: click the arrow-down button to call the Time calculator popup window.

 

Idle time

Specify the permitted periods of continuous inactive time (in minutes) during a session, or select DEFAULT or UNLIMITED from the drop-down list. For your convenience the Time calculator is implemented: click the arrow-down button to call the Time calculator popup window.

 

Logical reads per session

Specify the permitted number of data blocks read in a session, including blocks read from memory and disk, or select DEFAULT or UNLIMITED from the drop-down list.

 

Logical reads per call

Specify the permitted number of data blocks read for a call to process a SQL statement (a parse, execute, or fetch), or select DEFAULT or UNLIMITED from the drop-down list.

 

Composite limit

Specify the total resource cost for a session (expressed in service units), or select DEFAULT or UNLIMITED from the drop-down list.

 

Private SGA

Specify the amount of private space a session can allocate in the shared pool of the system global area (SGA), or select DEFAULT or UNLIMITED from the drop-down list. For your convenience the Byte calculator is implemented: click the arrow-down button to call the Byte calculator popup window.

 

Password parameters

 

Failed  login attempts

Specify the number of failed attempts to log in for the user account before the account is locked, or select DEFAULT or UNLIMITED from the drop-down list.

 

Password lifetime

Specify the number of days the same password can be used for authentication, or select DEFAULT or UNLIMITED from the drop-down list. For your convenience the Time calculator is implemented: click the arrow-down button to call the Time calculator popup window.

 

Password reuse time

Specifies the number of days before which a password cannot be reused, or select DEFAULT or UNLIMITED from the drop-down list. For your convenience the Time calculator is implemented: click the arrow-down button to call the Time calculator popup window.

 

Password reuse max

Specifies the number of password changes required before the current password can be reused, or select DEFAULT or UNLIMITED from the drop-down list.

 

Password lock

Specify the number of days an account will be locked after the specified number of consecutive failed login attempts, or select DEFAULT or UNLIMITED from the drop-down list. For your convenience the Time calculator is implemented: click the arrow-down button to call the Time calculator popup window.

 

Password grace time

Specify the number of days after the grace period begins during which a warning is issued and login is allowed, or select DEFAULT or UNLIMITED from the drop-down list. If the password is not changed during the grace period, the password expires. For your convenience the Time calculator is implemented: click the arrow-down button to call the Time calculator popup window.

 

Password verify function

Lets a PL/SQL password complexity verification script be passed as an argument to the CREATE PROFILE statement, or select DEFAULT or NULL from the drop-down list.

 

To compile the object, use the corresponding Compile item of the Navigation bar or toolbar.