cancel
Showing results for 
Search instead for 
Did you mean: 

tables of risk analysis GRC - AC

Former Member
0 Kudos

Can anyone tell me the names of the tables of risk analysis GRC - AC ?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Dear Carlos,

One of the most important requirement is to make sure that the repository data is synced to the GRC box. Some of the important repository tables in the GRC system are

  • GRACUSERCONN 
  • GRACRLCONN

The generated rule for the Risk Id's are stored in the following tables

  • GRACACTRULE
  • GRACACTRULEEXT

If you are using the online(ad-hoc) risk analysis the violations will be fetched at run time but if you are using the Offline risk analysis the result will be stored in the risk analysis result will be stored in the following tables

Action level violations

  • GRACUSERACTVL
  • GRACROLEACTVL
  • GRACPROFILEACTVL

Permission level violations

  • GRACUSERPRMVL
  • GRACROLEPRMVL
  • GRACPROFILEPRMVL

I hope this will help.

Thanks & Regards

Japneet Singh

Answers (2)

Answers (2)

Colleen
Advisor
Advisor
0 Kudos

Hi Carlos

Fernando asked a valid point

For 5.3 (Java Stack) tables begin with 'VIRSA'. E.g all RAR tables are 'VIRSA_CC*'

For 10.0 most Access Control tables begin with GRAC*. Exceptions are the MSMP/WF (some are GRFNW* - or similar) and Mitigating Controls (HRP* tables)

It might be best to give more details or what you are specifically after. If not, go into edit mode and then check SM12 table locks and it'll show you most of the tables.

ST05 trace if all else fails and you'll see the SQL statements.

Former Member
0 Kudos

Dear Carlos,

Are you using GRC 5.3 or GRC 10.0?

Thank you,

Fernando

former_member185447
Active Contributor
0 Kudos

Some of the Important tables in GRC AC 10.0

GRACACTUSAGE
-Action Usage
GRACROLEUSAGE
-Role Usage
GRFNCONNSCNLK
-To Check whether integration scenarios are connected properly or not.
GRACCONNSTAT
-Consists of all the RFC's Created for GRAC