How to identify the DLP database schema name
search cancel

How to identify the DLP database schema name


Article ID: 238966


Updated On:


Data Loss Prevention Enforce


We need to connect on the DLP database schema name. 

How can we uncover the name of the DLP schema from database or can we see this on the Enforce settings?


Release : 15.8

Component :


While logged into Sqlplus as SYSADMIN you can run this command to give you a list of schemas available in the Oracle Database: 

select distinct owner from dba_objects;

Alternatively, while logged into Sqlplus as the DLP schema owner (default being protect) run this command to get the schema name:

select sys_context( 'userenv', 'current_schema' ) from dual;

Additional Information

The default schema name is PROTECT. We don't recommend customers change it. 


Additional articles which may be of interest:

Article ID: 160251 - Test the Oracle database connection string used by DLP Enforce

Article ID: 195876 - Understanding the Oracle Database Connection Methods Used by Data Loss Prevention