Skip to Content
1
Former Member
Jul 04, 2013 at 07:15 AM

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

426 Views

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..