Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Restricting BEx query view overwrite

Former Member

‎12-05-2006 7:49 PM

0 Kudos

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

1 REPLY 1

Former Member

‎08-02-2008 5:54 PM

0 Kudos

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.