Verify the Protect User permissions prior to an installation or upgrade.
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.
Grant Statements to correctly set permissions
Imported Document Id
This is machine translated content
Login to Subscribe
Please login to set up your
Would you like to be subscribed to future notifications for this article?
For security reasons, your link to this document has expired. Please click on the attachment link to access this file.
The attachment that you are looking for no longer exists.
There has been an issue retrieving your attachment. Please try again.
Currently server is down.
Didn't find the article you were looking for? Try these resources.