on 04-02-2014 2:06 PM
Dear Experts,
Can anyone let me know the table where rejected requests( regarding User creation through access management) is stored?.
The scenario is i have a Z-Program which excutes every 30min's and updates my Flag( as either Rejected/Approved) for a provided user id. For approved request's i can refer the table GRFNMWRTINST . But i cannot find the table where Rejected entries for a user creation is stored...
(The table GRFNMWRTINST : does not give information that USER_ID has been rejected, It has only apporval status as REJECTED but not the USERID).
In short, if there are two user creation requests ( say's user id : USER1, USER2). Request containing USER1 is rejected and Request containing USER2 is approved. So when i run my program, database entires should be updated as below
USER_ID(field) | Request_Status(field) |
USER1 | REJECTED |
USER2 | APPROVED |
Thanks
KH
Hi,
- request level - GRFNMWRTINST in column "APPROVAL_STATUS"
- line item level - in table GRFNMWRTDATLG column LINEITEM_STATUS
details regarding requests and line items you could find in tables:GRACREQ*
if you combine those tables, you should get all required info.
Best regards, Andrzej
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.