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

Need information on Oracle DB Grant and Revoke Access JSON

sk
Regular Contributor
Regular Contributor

HI Team,

Can someone please give the correct syntax for Add and Remove access JSON for the below query format.

Currently we are executing below commands to assign or remove from role in database.

Grant "SAV_RO_ROLE" to "User";

Revoke "SAV_RO_ROLE" from "User";

Regards.

Sai Krishna

1 REPLY 1

rushikeshvartak
All-Star
All-Star

Refer below

Here Role is Entitlement Type Name

GRANTACCESSJSON{ "Role" : ["GRANT \"${task.entitlement_valueKey.entitlement_value}\" TO \"${accountName}\" "]}
REVOKEACCESSJSON{ "Role" : ["REVOKE \"${task.entitlement_valueKey.entitlement_value}\" FROM \"${accountName}\" "]}

 

 


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