How to verify if DDS (Deep data Security) is enabled in Oracle database 26 ai

May 31, 2026 [email protected] Oracle AI Database 26ai, 0

Introduction
Deep Data Security (DDS) in Oracle Database 26ai is the new database‑native authorization framework that protects enterprise and AI‑driven workloads by enforcing identity‑aware, context‑aware, fine‑grained access control directly inside the database. It is designed specifically for the era of agentic AI, where AI agents dynamically generate SQL and can bypass traditional application‑layer guardrails.
Deep Data Security (DDS) can exist in your Oracle Database — but only if the DDS dictionary components were installed.

Check the database version from SQL
Connect as SYS or any privileged user:

SELECT * FROM v$version;

Oracle AI Database 26ai Free Release 23.26.1.0.0 - Develop, Learn, and Run for Free

✅ 1. Check if the DDS package exists

SELECT object_name, status
FROM dba_objects
WHERE object_name = 'DBMS_DDS'
  AND owner = 'SYS';

If you get 1 row → DDS is installed.
If you get 0 rows → DDS is not installed.

✅ 2. Check if DDS dictionary views exist

DDS uses these views:
DBA_DDS_POLICY_CLASSES
DBA_DDS_POLICY_GROUPS
DBA_DDS_POLICY_TARGETS

SELECT view_name
FROM dba_views
WHERE view_name LIKE 'DBA_DDS%';

If these views exist → DDS is installed and configured.

✅ 3. Check if DDS metadata protection is enabled
DDS requires dictionary protection to be active.

SELECT *
  FROM v$option
 WHERE  parameter = 'Data Dictionary Protection';

If VALUE = TRUE, DDS can be used.

✅ 4. Check if you can execute DDS procedures

SELECT * 
FROM dba_tab_privs
WHERE table_name = 'DBMS_DDS';

You need:
EXECUTE on DBMS_DDS
SYS or DV_OWNER privileges for policy creation

Interpretation Guide

Next Post will cover DDS configuration

How to configure Oracle Managed Files (OMF) in Oracle Database 26ai (CDB/PDB)