BW Authorisation on Adhoc Queries

[Former Member]

Hello All

An authorisation question on BW. We want to give BW users the the permissions to save queries (created using the Adhoc Query Designer) to a designated role. Further, users should only be limited to modifying their own queries and denied modify access to others' queries.

If any of you have done this, is there a particular Authorisation object I should be looking to make the following restrictions:

1. Allow users to save to a particular role.

2. restrict modify access to be limited to the queries created by the user.

Much appreciate any suggestions/ideas/thoughts.

N

[Former Member]

Hi,

Use S_RS_COMP1 multiple times, and give the combination '02' and '$user' for activity and owner components . This will allow the user to modify hios own queries without changing the others.

Hope this helps.

Regards,

Raju Veludandi.

[Former Member]

Hi naveen!

I think you can do this by seting the Authorization object of the report owner to the follwing my give you this result RSZOWNER = "$USER" allows the user access to activities in all the components he is an owner of.

you can have more help in help.sap.com in underthe follwing structure

BW 3.1 content

-> systemadministration tasks-> authorizations-> authorizations for working with business explorer-> and examples for reporting authorizations

Message was edited by: ashwin gadi