Skip to Content
avatar image
Former Member

Restricting BEx query view overwrite


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?



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 02, 2008 at 04:54 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded