GRC 5.2 Java Tables for Role owners

[Former Member]

Dear All,

We have requirement in Access Enforcer 5.2 to review the Roles loaded into the system and their role owners in the various systems.( I know this can be got from the informer tab - but that is inflexible and does not give us the information in any workable way)

We will use SQL via AE/opensql_test.jsp as this will allow an SQL statement to be written.

Can anyone tell us the java table in which the Role Owner details are stored. We have access to database. (ie the table that is written to via RoleImport.xls)

Thanks & Regards,

GRC Team.

[Former Member]

Look in VIRSA_AE_RLOWNER this may need to be merged with other AE role tables.

VIRSA_AE_RLCMPNY TABLE

VIRSA_AE_RLCTMFLD TABLE

VIRSA_AE_RLDEFAULT TABLE

VIRSA_AE_RLFA TABLE

VIRSA_AE_RLOWNER TABLE

VIRSA_AE_RLREAFRM TABLE

VIRSA_AE_RL_CRLVL TABLE

VIRSA_AE_ROLDTLS TABLE

VIRSA_AE_ROLEAPRV TABLE

VIRSA_AE_ROLE_MAP TABLE

VIRSA_AE_ROLE_TYPE TABLE

Ken

[Former Member]

Thanks Ken,

For completeness, I have obtained and listed all the Virsa AE tablenames below (that have data in our system).

VIRSA_AE_APPLN_LOG

VIRSA_AE_APPL_SEQ

VIRSA_AE_ATTUDFDTL

VIRSA_AE_ATTUDFMAP

VIRSA_AE_BAPI_MAP

VIRSA_AE_BUSSPROC

VIRSA_AE_BUSUBPRO

VIRSA_AE_CACHE_MGR

VIRSA_AE_CDTVALAPP

VIRSA_AE_CNT

VIRSA_AE_CNT_LDAP

VIRSA_AE_CNT_SAP

VIRSA_AE_CTMDT

VIRSA_AE_CTMDTATT

VIRSA_AE_CTMDTNM

VIRSA_AE_CTMDTVAL

VIRSA_AE_CTMDTWS

VIRSA_AE_CTMFLD

VIRSA_AE_CTMFLDDS

VIRSA_AE_CTMFLDPRP

VIRSA_AE_CTMFLDVAL

VIRSA_AE_CUST_PAGE

VIRSA_AE_DFLT_ROLS

VIRSA_AE_DLEGAPROV

VIRSA_AE_DSRC_CNFG

VIRSA_AE_DSRC_CNT

VIRSA_AE_EMLLOG

VIRSA_AE_ERMCONFIG

VIRSA_AE_FLDDEFN

VIRSA_AE_FLDMAPGRP

VIRSA_AE_FN_AREA

VIRSA_AE_GRPAPPLN

VIRSA_AE_INTR_ATTR

VIRSA_AE_LDAPFLDMP

VIRSA_AE_MESSAGE

VIRSA_AE_MSG_PRMS

VIRSA_AE_MSG_TYP

VIRSA_AE_REQD_HDR

VIRSA_AE_RLFA

VIRSA_AE_RL_CRLVL

VIRSA_AE_ROLDTLS

VIRSA_AE_ROLEAPRV

VIRSA_AE_ROLE_MAP

VIRSA_AE_ROLE_TYPE

VIRSA_AE_RQD_APL

VIRSA_AE_RQD_CSFLD

VIRSA_AE_RQD_MTGTN

VIRSA_AE_RQD_PDPRL

VIRSA_AE_RQD_RLPRL

VIRSA_AE_RQD_SODCF

VIRSA_AE_RQD_USERS

VIRSA_AE_RQD_WPCLD

VIRSA_AE_RQD_WPHST

VIRSA_AE_RQD_WPTRN

VIRSA_AE_RQ_EMPTP

VIRSA_AE_RQ_HST

VIRSA_AE_RQ_PRTY

VIRSA_AE_RQ_TYP

VIRSA_AE_SCHEDULER

VIRSA_AE_SCRTYINF

VIRSA_AE_SQ_DFN

VIRSA_AE_SYSROLE

VIRSA_AE_THEME

VIRSA_AE_USRDFL

VIRSA_AE_USR_INFO

VIRSA_AE_USR_SEQ

VIRSA_AE_WFSTGDTR

VIRSA_AE_WFTYPE

VIRSA_AE_WF_ESCCON

VIRSA_AE_WF_INTATR

VIRSA_AE_WF_INTDTR

VIRSA_AE_WF_PTH

VIRSA_AE_WF_PTSTG

VIRSA_AE_WF_RQNTFC

VIRSA_AE_WF_RQNTFR

VIRSA_AE_WF_STAGE

VIRSA_AE_WF_STGACN

VIRSA_AE_WF_STGESC

VIRSA_AE_WF_STGFLD

VIRSA_AE_WF_STGNCT

VIRSA_AE_WF_STGNRL

VIRSA_AE_WRKFLAPVR

Usefull to know.

Thanks again.

GRC Team