To verify the PROTECT User permissions for proper DLP function or prior to an installation or upgrade.
Note: This script can be used to revise permissions on the UPGRADE READINESS user as well.
There are various Oracle database permissions that the Protect User is granted during oracle install by using the "oracle_create_user.sql" script.
To verify permissions or to make sure the correct permissions are set for the protect user, you can run the attached "Grant_protect_permissions.sql" script against the Oracle database while being logged in sys as sysdba to the Oracle system.
Note: If the permissions are already set correctly running the script will not hurt anything, and if there are permissions missing or needing to be reset the script will grant the protect user the appropriate permissions or set the permissions that are missing.
Note: you may also run the script against the Oracle 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168, and 12c systems that the DLP System uses.
The following information or grant statements are in the SQL script that you can run. If your Oracle user created during Oracle install is different than the default "Protect" user, you can open the script in a text editor and replace the protect user with the user you created during Oracle install while running the oracle_create_user.sql file.