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

VIEW: JTF.JTF_DAC_ROLE_PERM_CRIT#

Object Details
Object Name: JTF_DAC_ROLE_PERM_CRIT#
Object Type: VIEW
Owner: JTF
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROLE_PERM_CRIT_ID NUMBER
Yes
ROLE_PERM_ID NUMBER
Yes
CRITERIA_ID NUMBER
Yes
JTF_AUTH_PRINCIPAL_ID NUMBER
Yes
JTF_AUTH_PERMISSION_ID NUMBER
Yes
PRINCIPAL_NAME VARCHAR2 (255) Yes
PERMISSION_NAME VARCHAR2 (255) Yes
BASE_OBJECT VARCHAR2 (255) Yes
BASE_OBJECT_TYPE VARCHAR2 (32) Yes
START_ACTIVE_DATE DATE

END_ACTIVE_DATE DATE

PROPERTY_NAME VARCHAR2 (80) Yes
OPERATOR VARCHAR2 (20) Yes
PROPERTY_VALUE VARCHAR2 (2000) Yes
PROPERTY_VALUE_TYPE VARCHAR2 (20) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

OBJECT_VERSION_NUMBER NUMBER

SECURITY_GROUP_ID NUMBER

Query Text

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


SELECT ROLE_PERM_CRIT_ID
,      ROLE_PERM_ID
,      CRITERIA_ID
,      JTF_AUTH_PRINCIPAL_ID
,      JTF_AUTH_PERMISSION_ID
,      PRINCIPAL_NAME
,      PERMISSION_NAME
,      BASE_OBJECT
,      BASE_OBJECT_TYPE
,      START_ACTIVE_DATE
,      END_ACTIVE_DATE
,      PROPERTY_NAME
,      OPERATOR
,      PROPERTY_VALUE
,      PROPERTY_VALUE_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
FROM JTF.JTF_DAC_ROLE_PERM_CRIT#;

Dependencies

[top of page]

JTF.JTF_DAC_ROLE_PERM_CRIT# references the following:

SchemaJTF
TableJTF_DAC_ROLE_PERM_CRIT
JTF.JTF_DAC_ROLE_PERM_CRIT# is referenced by following:

SchemaAPPS
SynonymJTF_DAC_ROLE_PERM_CRIT