How to upgrade without access to the SYS account


Article ID: 159688


Updated On:


Data Loss Prevention Enforce


In a lot of instances the person who installs/upgrades DLP does not have access to the SYS account. Only access point is the DBA team.


Relevant Versions:  7.0, 7.1 and 7.2

The instructions to upgrade without sys are similar to the ones with sys. There are two differences.

First, there is a script run_as_sys.sql. This script needs to be run by your DBAs before running the upgrader. We will assume that the script is run correctly, because we can not verify without the sys password. So, you need to make sure this is done beforehand.

Second, edit the file. The last line of the file is:

Uncomment this line

and save the file.

Once you have saved the file, you can follow the instructions for the upgrader. Instead of asking for the sys password, it will give you a warning and tell you that you need to run the script manually. Since you will have done that already, you can just hit return.