on 07-04-2013 8:15 AM
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..
You can use table GRFNMWRTDATLG to get approvers of already approved stages
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi KT GRC,
Could you send me a print your query?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.