eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPLSYS.UMX_LSA_ROLE#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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