DBA Data[Home] [Help] [Dependency Information]

TABLE: PV.PV_ATTR_PRINCIPALS

Object Details
Object Name: PV_ATTR_PRINCIPALS
Object Type: TABLE
Owner: PV
Subobject Name:
Status: VALID


This table stores association information between JTF Roles and Profile Attributes. This data is used to determine if the user has access to the profile attribute (read,full or no access).


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PV_ATTR_PRINCIPALS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnATTR_PRINCIPAL_ID
PV_ATTR_PRINCIPALS_U2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnATTRIBUTE_ID
ColumnJTF_AUTH_PRINCIPAL_ID
Columns
Name Datatype Length Mandatory Comments
ATTR_PRINCIPAL_ID NUMBER
Yes Attribute Role Identifier. Primary Key column
ATTRIBUTE_ID NUMBER
Yes Attribute Identifier. Foreign Key to PV_ATTRIBUTES_B table.
JTF_AUTH_PRINCIPAL_ID NUMBER
Yes Foriegn key to JTF_AUTH_PRINCIPALS table.
OBJECT_VERSION_NUMBER NUMBER (9) Yes Object Version Number for Locking.
CREATED_BY NUMBER
Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER
Yes Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ATTR_PRINCIPAL_ID
,      ATTRIBUTE_ID
,      JTF_AUTH_PRINCIPAL_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM PV.PV_ATTR_PRINCIPALS;

Dependencies

[top of page]

PV.PV_ATTR_PRINCIPALS does not reference any database object

PV.PV_ATTR_PRINCIPALS is referenced by following:

SchemaAPPS
SynonymPV_ATTR_PRINCIPALS