Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | DATABASE_PROFILE |
| Short Name | DPR |
| View Name | CI_DATABASE_PROFILES |
| Description | A database profile is a set of limits on database resources and |
| parameters governing password control that can be assigned to one | |
| or more database users within the database on which the profile is | |
| defined. | |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Versioning: | Belongs to: ORACLE_DATABASE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
ORACLE_DATABASE_REFERENCE NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_DPR |
| Changes: | Summary of changes to DATABASE_PROFILE in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| ORACLE_DATABASE_REFERENCE | N |
Prompt: Oracle Database
Transferable only if null |
Must be defined in one and only one ORACLE_DATABASE | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| ACCOUNT_LOCK_TIME | VARCHAR2(16) | N | Number of days for which account should be locked after the specified number of failed login attempts
Prompt: Password Lock Time | PROFILE_ENTRY Non-enforced | DEFAULT |
| COMPOSITE_LIMIT | VARCHAR2(16) | N | Limits the total resource cost for a session. The total resource cost is a weighted sum of the following resources CPU_PER_SESSION, CONNECT_TIME, LOGICAL_READS_PER_SESSION and PRIVATE_SGA
Prompt: Composite Limit | PROFILE_ENTRY Non-enforced | DEFAULT |
| CONNECT_TIME | VARCHAR2(16) | N | Limits the total elapsed time of a session. Value is expressed in minutes.
Prompt: Connect Time | PROFILE_ENTRY Non-enforced | DEFAULT |
| CPU_PER_CALL | VARCHAR2(16) | N | Limits the CPU time for a call (a parse, execute, or fetch). Value is expressed in hundreths of seconds
Prompt: CPU Per Call | PROFILE_ENTRY Non-enforced | DEFAULT |
| CPU_PER_SESSION | VARCHAR2(16) | N | Limits the CPU time for a session. Value is expressed in hundreths of seconds
Prompt: CPU Per Session | PROFILE_ENTRY Non-enforced | DEFAULT |
| FAILED_LOGIN_ATTEMPTS | VARCHAR2(16) | N | Number of failed login attempts before lockout of the account
Prompt: Failed Login Attempts | PROFILE_ENTRY Non-enforced | DEFAULT |
| IDLE_TIME | VARCHAR2(16) | N | Limits periods of continuous inactive time during a session. Value is expressed in minutes. Long-running queries and other operations are not subject to this limit
Prompt: Idle Time | PROFILE_ENTRY Non-enforced | DEFAULT |
| LOGICAL_READS_PER_CALL | VARCHAR2(16) | N | Limits number of data blocks read for a call (a parse, execute or fetch) to an integer number of blocks
Prompt: Logical Reads Per Call | PROFILE_ENTRY Non-enforced | DEFAULT |
| LOGICAL_READS_PER_SESSION | VARCHAR2(16) | N | Limits number of data blocks read in a session, including blocks read from memory and disk to an integer number of blocks
Prompt: Logical Reads Per Session | PROFILE_ENTRY Non-enforced | DEFAULT |
| NAME | VARCHAR2(30) | N | Name of the database profile
Prompt: Name Uppercase | ||
| PASSWORD_GRACE_TIME | VARCHAR2(16) | N | Grace period in days for changing password after first successful login after password expired
Prompt: Password Grace Time | PROFILE_ENTRY Non-enforced | DEFAULT |
| PASSWORD_LIFETIME | VARCHAR2(16) | N | Lifetime of the password in days after which the password expires
Prompt: Password Lifetime | PROFILE_ENTRY Non-enforced | DEFAULT |
| PASSWORD_REUSE_MAX | VARCHAR2(16) | N | Maximum number of password changes before password is not allowed to be used again
Prompt: Password Reuse Max | PROFILE_ENTRY Non-enforced | DEFAULT |
| PASSWORD_REUSE_TIME | VARCHAR2(16) | N | Number of days before which a password cannot be reused
Prompt: Password Reuse Time | PROFILE_ENTRY Non-enforced | DEFAULT |
| PASSWORD_VERIFY_FUNCTION | VARCHAR2(7) | N | PL/SQL function where password complexity check is made before password is assigned
Prompt: Password Verify Function | DEFAULT_OR_NULL Non-enforced | DEFAULT |
| PRIVATE_SGA | VARCHAR2(16) | N | Limits amount of private space a session can allocate in the shared pool of the SGA to an integer number of bytes (if no units specified)
Prompt: Private SGA | PROFILE_ENTRY Non-enforced | DEFAULT |
| PRIVATE_SGA_UNITS | VARCHAR2(1) | Y | Units in which PRIVATE_SGA is expressed. A null value indicates bytes
Prompt: Private SGA Units Uppercase | OGO_UNITS_OF_QUOTA | |
| SESSIONS_PER_USER | VARCHAR2(16) | N | Limits the user to (integer) concurrent sessions
Prompt: Sessions Per User | PROFILE_ENTRY Non-enforced | DEFAULT |
| PARENT_IVID | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a versioning viewpoint. Contains the IVID of the primary element type (not necessarily a PAC) forming the basis of the "versionable object" to which this element type belongs
Not displayed System maintained Updatable only if null Defined on SAC supertype | ||
| PAC_REFERENCE | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a structural viewpoint. Contains the IRID of the PAC forming the basis of the "logical object" to which this element type belongs
Not displayed System maintained Not updatable by user Defined on SAC supertype | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| Other Properties |
|---|
| DATABASE_PROFILE has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility |
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference DATABASE_PROFILE:
Note: