This content has been marked as final. Show 5 replies
The C API is based on (provides) various App Manager functionality.
I'm curious why you say:
However, to run this one seems to have to be a database manager (at least).Are you catching errors and logging? If so, what messages are you observing when you try to access the outline? What indications are leading you to suspect that user security is the issue?
Thanks for the response.
When I run the app with a user ID with database manager rights it runs fine.
When I run with a read only user it returns the error:
‘Insufficient Privilege for this operation’ (error 1051041)
I had hoped that by not locking the otl and just reading it's contents it might be ok for a low level user to run?
I had a similar problem. After much trawling through the docs (EssOtlOpenOutline() documentation seems to imply you only need high-level permissions if you want to lock the outline) I came across this:
+"Because you can use the Outline API to create, edit, and delete outlines, you must be aware of some security issues when creating an application that uses the Outline API...+
+To manipulate outlines through the Outline Editor in Administration Services, you must have Application Manager or higher privileges. You also need these privileges to use a program that uses the Outline API during execution. If you do not have these privileges, Outline API calls that read or write outlines from the server do not work. See the Oracle Essbase Database Administrator's Guide for more detailed information on security and privilege levels."+
+"With the Outline API, you have the same ability to manipulate database outlines from within code as you have using the Outline Editor in Administration Services."+
So it seems that in order to use the Outline API, even for just querying and read-only stuff, you need super-powerful permissions rather than just the READ permission that you might have expected.
Edited by: zarquon on May 2, 2012 4:32 PM