topic Re: Restricting User from making changes to Query using 'Local View' in Application Development and Automation Discussions

Restricting User from making changes to Query using 'Local View'

Former Member — Fri, 05 Feb 2010 16:58:50 GMT

Hi All,

User should be able to run a report in BEX and change local view. But when they do this, they can then run a bex query and view all data regardless of the security access levels they have for reporting.

Users should be able to change local views but internally in BEX, it should still be checking thier access, so that they can view only data they have access to view.

PLease share your views on the above issue.

Thanks,

M.Thiyagarajan.

Re: Restricting User from making changes to Query using 'Local View'

Former Member — Fri, 05 Feb 2010 18:05:56 GMT

Access to a query is controlled through the objects S_RS_COMP, S_RS_COMP1 while access to data is controlled through analysis authorizations (or reporting authorizations depending on your version of BW). You can set up security so that users have changes for queries on a particular cube through S_RS_COMP but not have authorization to display all the data. Analysis authorizations are maintained in the object S_RS_AUTH and maintained through the transaction RSECAUTH. Hope this helps!

Regards,

Aninda

Re: Restricting User from making changes to Query using 'Local View'

Former Member — Mon, 08 Feb 2010 12:14:33 GMT

Hi Gupta,

Yes, security can be set up using the above objects,.

The user has been restricted to view part of data from a cube in the above scenario using hierarchy authorizations and the above said objects.

Thanks,

M.Thiyagarajan