My Oracle Support Banner

Data Redaction Not Affecting SYS (Doc ID 2874073.1)

Last updated on JULY 26, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Goal

Trying to create a Data Redaction policy that would affect the SYS user.

As users SYS and SYSTEM automatically have the EXEMPT REDACTION POLICY system privilege, when a policy is created, these users are not affected by the policy.

Can we revoke the EXEMPT DATA REDACTION system privilege from SYS?  If this is not possible, is there another way to mask data from the SYS access?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.