How to identify the DLP database schema name
search cancel

How to identify the DLP database schema name

book

Article ID: 238966

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

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?

Environment

Release : 15.8

Component :

Resolution

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