We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Grant Access JSON

Mortal
New Contributor III
New Contributor III

Hi
We're working on a task where we created entitlements (create user_priv, reload_priv) in database and then import them in saviynt. After that we created a role and assign imported entitlements to the role. Now If any user requested access for that role he should get this privileges in Database side as well. The idea is that we don't want to create a data entry in the target DB tables but create an actual user who can login to the database and these entitlement assignment is the privileges which are present in DB which we assign to the user to grant access to CREATE, DELETE, UPDATE the database. How can we configure GrantAccessJSON based on this?

Thanks

3 REPLIES 3

rushikeshvartak
All-Star
All-Star

You need to import privileges into saviynt and make them requestable to assign into database using grant access json


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Mortal
New Contributor III
New Contributor III

Is it possible to provide me a reference query?

Mortal
New Contributor III
New Contributor III

Hi @rushikeshvartak ,

In MySQL 5.7 version, RBAC is not present, so we created a table as entitlements and created privileges as an entitlement manually and imported them into Saviynt as entitlements. Now, if any user requested for add access for those entitlements from Saviynt, that account should have those privileges in database. How can we configure grant access Json based on these requirements? Do we need to configure stored procedure for it? If yes, what will be the procedure query?