Oracle DBMS_SENSITIVE_DATA
Version 26ai

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

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?
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