Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | SYSTEM_PRIVILEGE |
| Short Name | SPV |
| View Name | CI_SYSTEM_PRIVILEGES |
| Description | Privilege to perform a specific operation, given to an Oracle user, |
| a group of users or to Public. | |
| 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: |
SYSTEM_PRIVILEGE_NAME DATABASE_USER_REFERENCE ROLE_REFERENCE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_SPV |
| Changes: | Summary of changes to SYSTEM_PRIVILEGE 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 | 45 |
| ROLE_REFERENCE | N |
Prompt: Role
Transferable only if null |
Must be given to one and only one ROLE | 45 |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| GRANT_ACCESS_FLAG | VARCHAR2(1) | N | Indicates whether the user/group is to have the authority to grant this system privilege on to other users/groups
Prompt: With Admin Option ? Uppercase | YESNO | N |
| GRANT_OPTION_TO | VARCHAR2(3) | N | Arc 45 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 | |
| REMARK | VARCHAR2(240) | Y | A comment or description on the granting of privileges.
Prompt: Comment | ||
| SYSTEM_PRIVILEGE_NAME | VARCHAR2(16) | N | The name of the system privilege
Prompt: Privilege Name Uppercase | SYSTEM_PRIVILEGES | |
| 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 |
|---|
| SYSTEM_PRIVILEGE 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 SYSTEM_PRIVILEGE:
Note: