Click HERE to see how Saviynt Intelligence is transforming the industry. |
07/12/2024 05:49 AM
Hi Team,
We are using a stored procedure to perform account/access removal using a DB connection.
We have a specific case that the stored procedure should not delete the account or access from DB in case the account is present in a specific table. For this case, the App team is providing an output response that will mention the reason why the account can not be deleted through the stored procedure.
Is it possible to display that output message from Stored Procedure in Saviynt anywhere?
If not, what other approach could we take here?
Queries run by stored procedure are below -
/*CHECK IF THE APPLICATION USER IS ASSOCIATED WITH ANY CRO PERSON RECORD*/
1. SELECT COUNT(*) FROM CRO_XXXX p WHERE p.USER_TKEY = '?';
/*IF COUNT(*) >0 CAN'T DELETE THIS USER WITH ERROR MESSAGE- ERROR:There is a CRO XX PERSON linked to this Application User.*/
/*IF COUNT(*) =0 PROCEED WITH DELETION*/
2. DELETE FROM USER_SESSIONS A WHERE A.USER_TKEY = '?';
__________________________________________________________________________
Below is the stored proc -
DECLARE
result VARCHAR2(200);
BEGIN
SA_SAVIYNT_USER.SAVIYNT_USER_DELETION(‘<username>', result);
DBMS_OUTPUT.PUT_LINE(result);
END;
07/12/2024 05:50 AM
Currently the task for such user is getting successful but it is not actually deleting the user not displaying the error message
07/12/2024 06:09 AM
Hi @Gurukrishna96 , I don't think so in DB connector you can get call 1 response.
What will suggest store some identifier in accounts customproperty. And then make the call
07/12/2024 06:47 AM
OUT parameters is not supported by DB connector