Oracle Designer Model, Release 6i
Element Type Definition


Element Type Name ROLE_MODULE_ACCESS
Short Name GRPMOD
View NameCI_ROLE_MODULE_ACCESSES
Description Modules accessed by a role. This information can be used by CASE*Gene
Sub-type of INTERSECTION
Versioning: Belongs to:
ORACLE_DATABASE versionable object
Rules: API Spec
Uniqueness Criteria
Deletion Rules
Descriptor: ROLE_REFERENCE
GENERAL_MODULE_REFERENCE
Used by: Oracle Designer
Underlying table:SDD_GRPMOD
Changes: Summary of changes to ROLE_MODULE_ACCESS in Release 6i

Reference Properties
Name Opt ? Notes Relationship In Arc
GENERAL_MODULE_REFERENCE N Prompt: Module
Transferable only if null
Must be for one and only one GENERAL_MODULE
ROLE_REFERENCE N Prompt: Role
Transferable only if null
Must be given to one and only one ROLE

Properties
Name Datatype Opt ? Notes Domain Default Value
WITH_GRANT_OPT_IND VARCHAR2(1) N Allows the grantee to grant access to this module to other users.
Prompt: With Grant Option ?
Uppercase
YESNO N
PARENT_IVID NUMBER(38, 0) Y Internal use only. Common repository version identifier of owning PAC
Not displayed
System maintained
Updatable only if null
Defined on SE supertype
PAC_REFERENCE NUMBER(38, 0) Y Internal use only. Contains the IRID of the PAC for the "versionable object" to which this element belongs
Not displayed
System maintained
Not updatable by user
Defined on SE supertype

Multi-line Text
Name Text Type Prompt

Other Properties
ROLE_MODULE_ACCESS 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 ROLE_MODULE_ACCESS:


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