Oracle DBMS_SENSITIVE_DATA
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows
Purpose API for creating and managing Sensitive Data Masking policies.
AUTHID DEFINER
Constants
Name Data Type Value
 Mask Policies Types
policy_type_sys_context VARCHAR2(100) 'sys_context'
policy_type_row_level VARCHAR2(100) 'row_level'
policy_type_column_level VARCHAR2(100) 'column_level'
policy_type_column_level_filter VARCHAR2(100) 'column_level_filter'
Dependencies
ALL_USERS DUAL V$FIXED_TABLE
DBMS_STANDARD SENSITIVE_FIXED$ V$PARAMETER
DBMS_UTILITY    
Documented No
First Available 23ai
Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role
Source {ORACLE_HOME}/rdbms/admin/dbmssensdata.sql
{ORACLE_HOME}/rdbms/admin/prvtsensdata.plb
Subprograms
 
ADD_POLICY (new 23ai)
Undocumented dbms_sensitive_data.add_policy(
policy_type      IN VARCHAR2,
object_name      IN VARCHAR2,
policy_condition IN VARCHAR2 NOT NULL);
TBD
 
DROP_POLICY (new 23ai)
Undocumented dbms_sensitive_data.drop_policy(
policy_type      IN VARCHAR2,
object_name      IN VARCHAR2,
policy_condition IN VARCHAR2 NOT NULL);
TBD
 
UPDATE_POLICY (new 23ai)
Undocumented dbms_sensitive_data.update_policy(
policy_type      IN VARCHAR2,
object_name      IN VARCHAR2,
policy_condition IN VARCHAR2 NOT NULL);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_TSDP_MANAGE
DBMS_TSDP_PROTECT
DBMS_TSDP_PROTECT_INT
PSTDY_DATAPUMP_SUPPORT
TSDP$DATAPUMP
TSDP_ERROR_HANDLE
What's New In 21c
What's New In 26ai

Morgan's Library Page Footer
This site is maintained by Daniel Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved