Can the Oracle Database Privileges Be Removed After Configuration
Last updated on SEPTEMBER 11, 2017
Applies to:Hyperion Essbase - Version 188.8.131.52.000 and later
Information in this document applies to any platform.
There is a required setting called "DROP ANY SYNONYM" in the EPM Installation/Deployment Guide when using an Oracle Database.
As the database repository and settings would be owned by the Oracle hyperion application only, would like to know if the Oracle database privileges be removed after Configuration. This is because DROP SYNONYM will allow it to drop Hyperion objects only, but granting DROP ANY SYNONYM will allow it to drop objects in any other schema and not excluding system level objects.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms