Grant Access JSON

[Mortal]

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

[rushikeshvartak]

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

[Mortal]

Is it possible to provide me a reference query?

[Mortal]

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?