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

Variable for stored procedure

Gurukrishna96
New Contributor
New Contributor

Hi Team,

One of our DB apps is using a stored procedure to revoke access. 
The stored procedure is designed to take email as an input. We are bringing email in account's custom property. 
What variable could be used to call email in the input parameter? For ex we tried using - ${task.account.customproperty2} but it failed.

Procedure looks like - remove_all_access (email  varchar2, ioStatus in out number)

Any suggestions would be helpful.

Thanks.

 

3 REPLIES 3

rushikeshvartak
All-Star
All-Star

${user.email}


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

NM
Esteemed Contributor
Esteemed Contributor

Hi @Gurukrishna96 ,

Try account.customproperty2


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

naveenss
All-Star
All-Star

@Gurukrishna96 what is the error you're seeing for ${task?.account?.customproperty2} 

can you please share logs? also the full JSON.

 

Regards,
Naveen Sakleshpur
If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.