Oracle Local Database Access

[ShantanuKumar]

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?

[stalluri]

@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 

[rushikeshvartak · Accepted solution]

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