cancel
Showing results for 
Search instead for 
Did you mean: 

Where can I find Approver for Access requests? (Audit purpose)

Former Member
0 Kudos

Hi experts.

I have a need to find who approved each access request.

Which table contains information of approvers?

I have information in table GRACROLE, GRACROLEAPPRVR (Approvers for each roles) and

GRACREQ, GRACREQPROVITEM, GRACREQPROVLOG, GRFNMWRTINST, GRFNMWRTAPPR, GRFNMWRTMSGLG.

But non of that tables contains who approved the access request.

We have a system of 2 level approving system. So I need to find out who approved the request first and who is next.

At NWBC screen, I can see who approved the request by 'Search Request' but I need it took so long time if I see that one by one.

There's over 10000 requests in the system. So I really need to know table that contains approver information for each requests..

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

You can use table GRFNMWRTDATLG to get approvers of already approved stages

Former Member
0 Kudos

Thank you. I found that table and made a proper report!

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi KT GRC,

Could you send me a print your query?

former_member208271
Participant
0 Kudos

Hi

I have created a Query with tables GRACREQPROVLOG and GRACREQUSER to find the Request Approved by.

I'm not sure if there is a table to search and see future approvers.

Regards

Mustafa

Former Member
0 Kudos

Thank you! I've learned GRACREQUSER table from you It's useful.