Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Qian Dong: "Although I evaluated Oracle Maestro for only a couple of days, I must say I like what I saw in this product. I am going to place an order for this product.

Thank you for the good work".
Laurits Sogaard Nielsen: "Oracle Maestro (and also MS SQL Maestro) are the perfect substitutes for TOAD and in some ways also much better products (they are much cheaper, and the support is fast and easy). I'm looking forward to getting much more experience with both products, that already now have proven themselves to be fantastic".


Add your opinion

Oracle Maestro online help

Prev Return to chapter overview Next

Editing profile properties

User Profile Editor provides you with an ability to edit profile properties. The Properties tab allows you to change the user password and session options.



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.



The field displays the date the object was created.


Last DDL time

Use the field to find the date when the last data definition language (DDL) operation was performed on the current object. The Last DDL time can help you to find if any changes to the object definitions have been made on or after a specific time.




To apply the changes, select the Apply Changes item in the Navigation bar or use Ctrl+F9 or Ctrl+F7 shortcut keys.


It is also possible to modify object properties without opening the object editor: use the Object Properties item of the popup menu of the selected object from the explorer tree.

Prev Return to chapter overview Next