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 your catalog database: Each time you start Essbase Studio Server, the server will try to execute the following ALTER SYSTEM statement:
ALTER SYSTEM SET open_cursors=300 SCOPE=MEMORY
If the catalog user (specified in the server.properties file during configuration) does not have the privileges necessary to execute the ALTER SYSTEM statement, Essbase Studio will log a warning message and continue working.
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.