Element Type Definition: DATABASE

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	DATABASE_USER
Short Name	DBU
View Name	CI_DATABASE_USERS
Description	Definition of a named user within a specific database

Sub-type of	SECONDARY_ACCESS_ELEMENT
Versioning:	Belongs to: NON_ORACLE_DATABASE versionable object ORACLE_DATABASE versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	DATABASE_REFERENCE NAME
Used by:	Oracle Designer
Underlying table:	SDD_DBU
Changes:	Summary of changes to DATABASE_USER in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
DATABASE_REFERENCE	N	Prompt: Database	Must be on one and only one DATABASE
DATABASE_PROFILE_REFERENCE	Y	Prompt: Database Profile	May be assigned to one and only one DATABASE_PROFILE
DEFAULT_TABLESPACE_REFERENCE	Y	Prompt: Default Tablespace	May be assigned a default tablespace of one and only one TABLESPACE
TEMP_TABLESPACE_REFERENCE	Y	Prompt: Temporary Tablespace	May be assigned a temporary tablespace of one and only one TABLESPACE

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
COMPLETE_FLAG	VARCHAR2(1)	N	Indicates whether the definition of this user is complete and ready to be used by the generators Prompt: Complete ? Uppercase	YESNO	Y
INITIAL_PASSWORD	VARCHAR2(30)	N	An initial password for the ORACLE user. Prompt: Initial Password Uppercase
NAME	VARCHAR2(30)	N	The name of the ORACLE user. Prompt: Name Uppercase
REMARK	VARCHAR2(240)	Y	A comment about this ORACLE user who has access to the database objects. Prompt: Comment
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
DESCRIPTION	CDIDSC	Description
NOTES	CDINOT	Notes

Other Properties
DATABASE_USER 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: ID IRID IVID ELEMENT_TYPE_NAME DATE_CREATED CREATED_BY DATE_CHANGED CHANGED_BY NUMBER_OF_TIMES_MODIFIED TYPES

Other element types that reference DATABASE_USER:

Each BATCHLINE may be design capturing objects from one and only one DATABASE_USER
Each BASE_RELATION_LOCATION must be implemented from the schema of one and only one DATABASE_USER
Each DATABASE_USER_ROLE must be for one and only one DATABASE_USER
Each ORACLE_USER_MODULE_ACCESS must be of one and only one DATABASE_USER
Each DIAGRAM_ELEMENT_USAGE must be for one and only one CIELEMENT (in arc)
Each DOCUMENT_ATTACHMENT must be from one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each DATABASE_OBJECT_GRANT must be given to one and only one DATABASE_USER (in arc)
Each DB_OBJECT_IMPLEMENTATION must be in schema of one and only one DATABASE_USER
Each JAVA_MOD_IMPLEMENTATION may be a class obtained from schema of one and only one DATABASE_USER (in arc)
Each QUEUE_P_IMPLEMENTATION may be created in queue table in schema of one and only one DATABASE_USER
Each QUEUE_TABLE_IMPLEMENTATION may be referencing an Oracle type owned by one and only one DATABASE_USER
Each SERVER_OBJECT_USAGE must be for generation of one and only one CIELEMENT (in arc)
Each SYSTEM_PRIVILEGE must be given to one and only one DATABASE_USER (in arc)
Each TABLESPACE_QUOTA must be given to one and only one DATABASE_USER
Each EXTENDED_STRUCTURE_ELEMENT must be part of one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be use of one and only one ACCESS_CONTROLLED_ELEMENT

Note:

All properties are displayed and updatable by the user unless indicated otherwise

All reference properties are displayed and transferable unless indicated otherwise

All domains are enforced unless indicated otherwise

All properties and reference properties are defined on this element type unless indicated as inherited from a supertype