[Home] [Help] [Dependency Information]
Object Name: | JTF_DAC_ROLE_PERM_CRIT# |
---|---|
Object Type: | VIEW |
Owner: | JTF |
Subobject Name: | |
Status: | VALID |
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 |
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#;
|
|
|