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

Oracle Local Database Access

ShantanuKumar
New Contributor III
New Contributor III

We are migrating Application from on-premise IGA system to Saviynt.

We have many Apps which use Oracle Database Direct(Out of the Box) connector to manage access for any Oracle DBS roles such as DBA, SYS, SYSTEM etc.

The OOTB connector used in  on-premise IGA system doesn't have any SQL queries to provisioning or reconciliation and managed internally by SailPoint. Is there any connector Saviynt which can do similar jobs or do we need to ask DBA team to provide the required SQL queries or stored procedure to manage DBA roles?

2 REPLIES 2

stalluri
Valued Contributor II
Valued Contributor II

@ShantanuKumar 

  • Saviynt does not have an Oracle Database Direct connector that operates exactly like SailPoint’s out-of-the-box (OOTB) solution for managing DBA roles such as DBA, SYS, and SYSTEM. However, Saviynt does provide connectors for databases, including Oracle, but these typically require SQL queries or stored procedures to perform provisioning and reconciliation tasks.
  • In your case, you would likely need to coordinate with the DBA team to provide the necessary SQL queries or stored procedures to manage DBA roles, as the OOTB connectors in Saviynt may not have pre-built logic for these specific tasks. You can use Saviynt’s database connector with custom SQL queries to manage access and handle provisioning or reconciliation.
  1. Imports: You have to use Query to pull the data for users/accounts/access.
  2. Provisioning/de-provisioning: You can use Query/Stored Procedure.

    Database-Architecture 

Best Regards,
Sam Talluri
If you find this a helpful response, kindly consider selecting Accept As Solution and clicking on the kudos button.

rushikeshvartak
All-Star
All-Star

We have onboarded oracle database user access management. Once you provide required table access you can use standard database connector 


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