Element Type Definition: DATABASE_OBJECT

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	DATABASE_OBJECT_GRANT
Short Name	DOG
View Name	CI_DATABASE_OBJECT_GRANTS
Description	Privileges granted to a database user or a database role (including
	the PUBLIC role) on a specific database object (an implementation of a
	table, view. sequence, snapshot, PL/SQL or Java module, or a
	directory)

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:	DIRECTORY_REFERENCE JMI_REFERENCE PLSQL_MODULE_REFERENCE QUI_REFERENCE SEQUENCE_REFERENCE SNAPSHOT_REFERENCE TABLE_REFERENCE VIEW_REFERENCE DATABASE_USER_REFERENCE ROLE_REFERENCE
Used by:	Oracle Designer
Underlying table:	SDD_DOG
Changes:	Summary of changes to DATABASE_OBJECT_GRANT in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
DATABASE_USER_REFERENCE	N	Prompt: Database User Transferable only if null	Must be given to one and only one DATABASE_USER	88
ROLE_REFERENCE	N	Prompt: Role Transferable only if null	Must be given to one and only one ROLE	88
DIRECTORY_REFERENCE	N	Prompt: Directory Transferable only if null	Must be for one and only one DIRECTORY	93
JMI_REFERENCE	N	Prompt: Java Class Implementation Transferable only if null	Must be for one and only one JAVA_MOD_IMPLEMENTATION	93
PLSQL_MODULE_REFERENCE	N	Prompt: PL/SQL Implementation Transferable only if null	Must be for one and only one PLSQL_MOD_IMPLEMENTATION	93
QUI_REFERENCE	N	Prompt: Queue Implementation Transferable only if null	Must be for one and only one QUEUE_IMPLEMENTATION	93
SEQUENCE_REFERENCE	N	Prompt: Sequence Implementation Transferable only if null	Must be for one and only one SEQUENCE_IMPLEMENTATION	93
SNAPSHOT_REFERENCE	N	Prompt: Materialized View Implement'n Transferable only if null	Must be for one and only one SNAPSHOT_IMPLEMENTATION	93
TABLE_REFERENCE	N	Prompt: Table Implementation Transferable only if null	Must be for one and only one TABLE_IMPLEMENTATION	93
VIEW_REFERENCE	N	Prompt: View Implementation Transferable only if null	Must be for one and only one VIEW_IMPLEMENTATION	93

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
ALL_ACCESS_FLAG	VARCHAR2(1)	N	Indicates whether the user is to be granted the ALL access privilege for this object. Prompt: All Privileges ? Uppercase	YESNO	N
ALTER_FLAG	VARCHAR2(1)	N	Indicates whether the user is to be granted the ALTER privilege for this object. Prompt: Alter ? Uppercase	YESNO	N
CREATE_SYNONYM_FLAG	VARCHAR2(1)	N	Indicates whether a synonym is to be automatically created by the server generator when the grant is on a database object in a different schema to the user or role to which the grant is being given Prompt: Create Synonym ? Uppercase	YESNO	Y
DELETE_FLAG	VARCHAR2(1)	N	Indicates whether the user is to be granted the DELETE privilege for this object. Prompt: Delete ? Uppercase	YESNO	N
DEQUEUE_FLAG	VARCHAR2(1)	N	Indicates whether the user is to be granted DEQUEUE privilege in the case of a grant to a queue Prompt: Dequeue ? Uppercase	YESNO	N
ENQUEUE_FLAG	VARCHAR2(1)	N	Indicates whether the user is to be granted ENQUEUE privilege in the case of a grant to a queue Prompt: Enqueue ? Uppercase	YESNO	N
EXECUTE_FLAG	VARCHAR2(1)	N	Indicates whether the user is to be granted EXECUTE privilege in the case of a grant to a PL/SQL module Prompt: Execute ? Uppercase	YESNO	N
GRANT_ACCESS_FLAG	VARCHAR2(1)	N	Indicates whether the user is to have the authority to grant access privileges for this object to other users Prompt: With Grant Option ? Uppercase	YESNO	N
GRANT_OPTION_FOR	VARCHAR2(3)	N	Arc 93 discriminator. Indicates the element type the "for" arc is pointing at (table, view, snapshot, sequence, a PL/SQL module or a directory) Not displayed Uppercase System maintained Not updatable by user	GRANT_OPTION_FOR
GRANT_OPTION_TO	VARCHAR2(3)	N	Arc 88 discriminator. Indicates the element type the "given to" arc points at (GRP or DBU). Not displayed Uppercase System maintained Not updatable by user	GRANT_OPTION_TO
INDEX_FLAG	VARCHAR2(1)	N	Indicates whether the user is to be granted the INDEX privilege for this object. Prompt: Index ? Uppercase	YESNO	N
INSERT_FLAG	VARCHAR2(1)	N	Indicates whether the user is to be granted the INSERT privilege for this object. Prompt: Insert ? Uppercase	YESNO	N
READ_FLAG	VARCHAR2(1)	N	Indicates whether the user is to be granted READ privilege in the case of a grant to a directory Prompt: Read ? Uppercase	YESNO	N
REFERENCE_FLAG	VARCHAR2(1)	N	Indicates whether the user is to be granted the REFERENCE privilege for this object. Prompt: Reference ? Uppercase	YESNO	N
REMARK	VARCHAR2(240)	Y	A comment or description on the granting of privileges. Prompt: Comment
SELECT_FLAG	VARCHAR2(1)	N	Indicates whether the user is to be granted the SELECT privilege for this object. Prompt: Select ? Uppercase	YESNO	Y
UPDATE_FLAG	VARCHAR2(1)	N	Indicates whether the user is to be granted the UPDATE privilege for this object. Prompt: Update ? Uppercase	YESNO	N
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_OBJECT_GRANT 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_OBJECT_GRANT:

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 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