[Home] [Help] [Dependency Information]
Object Name: | GMD_SECURITY_PROFILES |
---|---|
Object Type: | TABLE |
Owner: | GMD |
FND Design Data: | GMD.GMD_SECURITY_PROFILES |
Subobject Name: | |
Status: | VALID |
Contains the Security Profiles assigned to an OPM Organization. The Organization reflects the Owning Organization from the Formula.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GMD_SECURITY_PROFILES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | SECURITY_PROFILE_ID |
GMD_SECURITY_PROFILES_I1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ORGN_CODE |
GMD_SECURITY_PROFILES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
OBJECT_TYPE
ASSIGN_METHOD_IND ACCESS_TYPE_IND ORGANIZATION_ID USER_ID RESPONSIBILITY_ID OTHER_ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SECURITY_PROFILE_ID | NUMBER | (15) | Yes | Security Profile Unique Identifier |
OBJECT_TYPE | VARCHAR2 | (15) | Yes | Object the Security Profile applies; for example, Formula. |
ASSIGN_METHOD_IND | VARCHAR2 | (1) | Yes | Indicates the method Formula Security is assigned to a user. Automatically when a formula is created or manually by the creator of the formula. |
ACCESS_TYPE_IND | VARCHAR2 | (1) | Yes | Indicates the access type given the user or responsibility; Update or View. |
ORGN_CODE | VARCHAR2 | (4) | Object's Owning Organization which controls security access to the object. A user must be associated with the organization to have access the organization's object data. | |
USER_ID | NUMBER | (15) | User Identifier of the individual user assigned access the owning organization's object data. | |
RESPONSIBILITY_ID | NUMBER | (15) | Responsibility Identifier of the Responsibility assigned access to the Owning Organization Object data. | |
OTHER_ORGN | VARCHAR2 | (4) | Organization other than the formula's owning organization. A user can be given access to the owning organization's formula if they are associated with the other organization specified. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
ORGANIZATION_ID | NUMBER | (15) | This is the organization ID column for the security profile | |
OTHER_ORGANIZATION_ID | NUMBER | (15) | This is the other organization id column for the security profile. |
Cut, paste (and edit) the following text to query this object:
SELECT SECURITY_PROFILE_ID
, OBJECT_TYPE
, ASSIGN_METHOD_IND
, ACCESS_TYPE_IND
, ORGN_CODE
, USER_ID
, RESPONSIBILITY_ID
, OTHER_ORGN
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ORGANIZATION_ID
, OTHER_ORGANIZATION_ID
FROM GMD.GMD_SECURITY_PROFILES;
GMD.GMD_SECURITY_PROFILES does not reference any database object
GMD.GMD_SECURITY_PROFILES is referenced by following:
|
|
|