Skip to Content
author's profile photo Former Member
Former Member

GRC 5.2 Java Tables for Role owners

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2010 at 07:50 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.