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

TABLE: APPLSYS.UMX_LSA_ROLE

Object Details
Object Name: UMX_LSA_ROLE
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.UMX_LSA_ROLE
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: UMX_LSA_ROLE_P
  1. ColumnADMIN_ROLE
  2. ColumnROLE_SET_ID
Indexes
Index Type Uniqueness Tablespace Column
UMX_LSA_ROLE_P NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnADMIN_ROLE
ColumnROLE_SET_ID
Columns
Name Datatype Length Mandatory Comments
ADMIN_ROLE VARCHAR2 (320) Yes
ROLE_SET_ID NUMBER (6) Yes
CAN_UPDATE NUMBER (1)
CAN_CREATE_GRANT NUMBER (1)
CAN_ALTER_HIERARCHY NUMBER (1)
CAN_ASSIGN NUMBER (1)
CAN_REVOKE NUMBER (1)
SECURITY_WIZARD NUMBER (1)
PRIVILEGE7 NUMBER (1)
PRIVILEGE8 NUMBER (1)
PRIVILEGE9 NUMBER (1)
PRIVILEGE10 NUMBER (1)
PRIVILEGE11 NUMBER (1)
PRIVILEGE12 NUMBER (1)
PRIVILEGE13 NUMBER (1)
PRIVILEGE14 NUMBER (1)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
Query Text

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


SELECT ADMIN_ROLE
,      ROLE_SET_ID
,      CAN_UPDATE
,      CAN_CREATE_GRANT
,      CAN_ALTER_HIERARCHY
,      CAN_ASSIGN
,      CAN_REVOKE
,      SECURITY_WIZARD
,      PRIVILEGE7
,      PRIVILEGE8
,      PRIVILEGE9
,      PRIVILEGE10
,      PRIVILEGE11
,      PRIVILEGE12
,      PRIVILEGE13
,      PRIVILEGE14
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPLSYS.UMX_LSA_ROLE;

Dependencies

[top of page]

APPLSYS.UMX_LSA_ROLE does not reference any database object

APPLSYS.UMX_LSA_ROLE is referenced by following:

SchemaAPPLSYS
ViewUMX_LSA_ROLE#