Restricting BEx query view overwrite

[Former Member]

All:

We are in BW 3.5. Our users access BEx reports via portal.

Our users can save a query view. They can share those views as well.

However, one user can overwrite a view saved by another user. We would like to restrict that access.

We want that any user should be able to see views saved by other users, s/he should be able to overwrite his/her own views. But s/he should not be able to overwrite views that are saved by others.

Does anyone know what needs to be done to achieve this?

Thanks,

Pranab

[Former Member]

The authorization object S_RS_FOLD needs to turn off to make u2018Infocubesu2019 options available to all user when they try to access query views. That makes any query view available in BW system accessible to all BW reports users. Every user will have access to create, display, change and overwrite any query view available in the system.

Add following manual entry in the RSZCONTROLTEXTS table:

LANGU = <space>; TARGETID = ID_FLAG_VIEW_SAVE_AUTH_CHECK; CAPTION = Y. These prerequisites ensure that the authorization check is performed for views when query views are created, changed, deleted and overwritten.