on 09-18-2013 2:39 PM
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
The generated rule for the Risk Id's are stored in the following tables
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
Permission level violations
I hope this will help.
Thanks & Regards
Japneet Singh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Carlos,
Are you using GRC 5.3 or GRC 10.0?
Thank you,
Fernando
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.