Installing the Views Package on the Symantec Data Loss Prevention Database errors

Products

• Data Loss Prevention
• Integrated Cyber Defense Exchange

Issue/Introduction

While following the instructions in the README.txt file to install the database views you observe oracle errors as below. * points to where problem is detected. 

SQL> @create_incident_access_user.sql
Enter the password for sys user:
Enter sid [default - protect]: protect
Enter user name to be created [default - icdx_user]:
Enter a password for the new user:
Connected.

Profile altered.

DROP USER icdx_user CASCADE
                      *
ERROR at line 1:
ORA-01918: user 'icdx_user' does not exist

CREATE USER icdx_user IDENTIFIED BY Pass!word
                                                                             *
ERROR at line 1:
ORA-00922: missing or invalid option

ALTER USER  icdx_user DEFAULT   TABLESPACE users
                        *
ERROR at line 1:
ORA-01918: user 'icdx_user' does not exist

ALTER USER  icdx_user TEMPORARY TABLESPACE temp
                        *
ERROR at line 1:
ORA-01918: user 'icdx_user' does not exist

TO icdx_user
      *
ERROR at line 6:
ORA-01917: user or role 'icdx_user' does not exist

Environment

Release : 15.7

Component : Default-Sym

Cause

Password for new user "Pass!word" has invalid characters as per oracle guidelines https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/keeping-your-oracle-database-secure.html#GUID-451679EB-8676-47E6-82A6-DF025FD65156

Resolution

Remove unsupported characters from password