Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This guide helps you establish data security in your mirrored Oracle in Microsoft Fabric.
Security requirements
Check the networking requirements to access your Oracle instance data source. Install an on-premises data gateway. The gateway machine's network must connect to the Oracle instance via a private endpoint or be allowed by the firewall rule.
Fabric needs to authenticate to the Oracle instance. For information about the required permissions, see Required Permissions.
To configure mirroring for an Oracle database:
- Ensure the database is in ARCHIVELOG mode and keep it enabled.
- Enable supplemental logging at the database level, including primary key supplemental logging.
- For every table selected for mirroring, enable all-columns supplemental logging at the table level.
Our system will attempt to apply these settings automatically. If the Oracle user lacks the ALTER DATABASE and ALTER TABLE privileges, a DBA must enable supplemental logging at both the database and table levels—adding supplemental log data for the database and enabling full column logging on each table to be mirrored.
For more information, see the requirements for setting up Oracle mirroring.
Data protection features
You can secure column filters and predicate-based row filters on tables to roles and users in Microsoft Fabric:
You can also mask sensitive data from non-admins using dynamic data masking: