How to determine which Oracle schema owns Symantec DLP
Last Updated January 05, 2011
In earlier versions of Vontu hardcoded references required the Oracle schema owner to be named "protect". As of version 9.x, this issue was resolved and the schema could be owned by any non-Oracle account, although the default is still "protect".
The following script can be used to determine Vontu schema ownership.
- this script must be run from SQLPlus as sys as sysdba.
The script shows the name of the owner of a short set of tables and indexes. All objects should have the same owner.
select owner, table_name TableIndex from dba_tables where table_name in ('MESSAGE','MESSAGELOB','INCIDENT') union select owner, index_name TableIndex from dba_indexes where index_name in ('MESSAGE_FK1','MESSAGELOB_PK','INCIDENT_N4') /