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

TABLE: QA.QA_GRANTED_PRIVILEGES

Object Details
Object Name: QA_GRANTED_PRIVILEGES
Object Type: TABLE
Owner: QA
FND Design Data: TableQA.QA_GRANTED_PRIVILEGES
Subobject Name:
Status: VALID


Granted privileges for data security project


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QA_GRANTED_PRIVILEGES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnQA_GRANT_ID
Columns
Name Datatype Length Mandatory Comments
QA_GRANT_ID NUMBER
Yes Grant ID
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER
Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
CREATED_BY NUMBER
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
GRANTEE_ID NUMBER
Yes Grantee ID
PLAN_ID NUMBER
Yes Plan ID
SETUP_FLAG RAW (16)
Setup Privilege
ENTER_FLAG RAW (16)
Enter Privilege
VIEW_FLAG RAW (16)
View Privilege
UPDATE_FLAG RAW (16)
Update Privilege
DELETE_FLAG RAW (16)
Delete Privilege
Query Text

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


SELECT QA_GRANT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      GRANTEE_ID
,      PLAN_ID
,      SETUP_FLAG
,      ENTER_FLAG
,      VIEW_FLAG
,      UPDATE_FLAG
,      DELETE_FLAG
FROM QA.QA_GRANTED_PRIVILEGES;

Dependencies

[top of page]

QA.QA_GRANTED_PRIVILEGES does not reference any database object

QA.QA_GRANTED_PRIVILEGES is referenced by following:

SchemaQA
ViewQA_GRANTED_PRIVILEGES#