Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to grant AW objects to users other than the owner?

366678Mar 26 2005 — edited Apr 7 2005
Hi,

I want to know how to grant AW objects to users other than the owner of those objects. For example, let user1 use discovere olap to access a cube within the aw owned by awuser.

Before 10.1.0.3, views and olap2 meatadata must be created for olapapi to access cubes in aw. So we can grant priviledge on cubes via granting priviledge on the corresponding views. But in the new version of olap10g, there is a active catalog, and it's not required to create views for olapapi access. If we don't have views created, how to grant priviledges on aw cubes? Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 5 2005
Added on Mar 26 2005
4 comments
286 views