Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Stored Procedure GrantAccess Json Issue

mahammed_raffi
New Contributor II
New Contributor II

Hi Team, 

Through the createAccount JSON (DB Connector), we are creating the account in the Target DB. As soon as the createAccount process is successful, the respective stored procedure generates the ClientID and UserID as outputs, which are then stored in the database itself. 

Now, the requirement is to pass the already generated ClientID and UserID (created through createAccount) values in the GrantAccess JSON. Please let us know if you have any ideas or logic to achieve this scenario. The app team mentioned that they can update the stored procedure to provide these two values as OUT parameters. Can Saviynt accept OUT parameters?

 

Thanks,

Rafi

2 REPLIES 2

NM
Esteemed Contributor
Esteemed Contributor

@mahammed_raffi currently mapping response isn't supported.


If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'

rushikeshvartak
All-Star
All-Star
  • Stored Procedure OUT parameters are not supported.
  • Ask app team to update stored procedure such that it internally select query and find that information

Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.