The Essbase Studio catalog database user must have at least write permission to the Essbase Studio catalog database. The catalog database user is the user specified in the catalog.username and catalog.password properties in the server.properties file. This user must have at least write permission to the database specified in the catalog.db property.
If Oracle is used for your Essbase Studio catalog database, Oracle recommends setting the following privileges for the user that is used to connect to catalog database.
open_cursors=nnn SCOPE=MEMORY
where nnn >= 300.
When setting up a data source connection in the Connection Wizard, Essbase Studio users must specify a user name and password that has at least read permission to the external data source (database) to which they are connecting.
Oracle recommends that users have only read permission to external data sources in order to prevent problems resulting from the use of Template SQL for drill-through reports and custom data load SQL.