How to get audit trail for user's access in GRC?

[Former Member]

Dear GRC Experts,

I need a report showing the audit trail for the
users, who approved, what roles assigned, etc in the access requests.

I could not find these reports for large number of users.

Can you advise the best way for me to get
that?

Regards,

Sindhu

[madhusap · Accepted solution]

Hi Sindhu,

You can pull the data by using GRC tables GRACREQ and GRACREQPROVLOG

Regards,

Madhu.

[Former Member · Accepted solution]

Hi Madhu,

Thank you very much for response and the solution.

I have read couple of your blogs and its really helpful and informative which has resolved some of my GRC issues .

Let me check the tables, do we have any available audit reports in NWBC for the access requests, i could not find one?

Regards,

Sindhu

[madhusap · Accepted solution]

Hi Sindhu,

In NWBC there is no detailed report as such but you can make use of these tables and can pull the report.

GRACREQ

GRACREQOWNER - This will give Creator, Manager and Requestor details. If your role owner is standard role owner agent then you can gets the details from table GRACROLEAPPRVR using the role names from GRACREQPROVLOG

GRACREQPROVLOG

Finding current approvers, etc will depend on what you MSMP Agent definitions are, etc. You might find it easier to trace the access request in ST05/STAUTHTRACE and look at the SQL statements, or look at the MSMP Instance Runtime report and leverage the code

Regards,

Madhu.