topic Problem with Workbooks in Application Development and Automation Discussions

Problem with Workbooks

Former Member — Thu, 25 Oct 2007 19:52:36 GMT

Hello Friends

I have a problem with workbook.

My end users are able to change the workbook and save it.

They are able to delete rows from workbook and save them.

S_USER_AGR has the Display activity and Menu role name as VALUES.

Please suggest some solutions,

Thnaks,

Ram

Re: Problem with Workbooks

Former Member — Fri, 26 Oct 2007 10:38:32 GMT

Hello Ram,

could you please give more information which application you are talking of. Which transaction ?

regards Wolfrad

Re: Problem with Workbooks

Former Member — Fri, 26 Oct 2007 13:23:43 GMT

Thanks for Response.

Here is the situation.I have end user with 4 roles.

1.General Role-It has general authorizations for the user and has S_RFC,S_TCODE,S_GUI,some authorizations for SPOOL and BACKGROUND JOBS, and

S_BDS_DS with values

ACTVT 03,30,

CLASSNAME--ALVLAYOUTTEMPLATES,BW_CATLOGS.

CLASSTYPE--BO,OT

2.General Menu Role for user.

3.BW MENU ROLE---it has queries and workbooks.

4.Authorization role for BW--has S_RS_AUTH

S_RS_COMP

S_RS_COMP1

S_RS_HIER

S_RS_ICUBE

S_RS_MPRO

S_RS_ODSO

and analysis Authorizations.

Problem is.

Now when user opens workbook and executes it the workbook is populated with newdata.

The user is able to delete the rows and save the work book.

Say when he opened workbook he has 10 rows.Now he deleted 2 rows and saved and closed the work book.

Now when he opens again he can see only 8 rows because he deleted 2 rows.When he executes workbook only 8 fields are populated.

Its security breach.Can you suggest me how to remove This SAVE option.

When he hits button save he gets option SAVE WORKBOOK AS.

SAVE WORKBOOK

SAVE WORKBOOK VIEW.

I want to restrict user with SAVE option.

NOTE:when i run query i get 10 rows .

But i execute workbook i dont get the 10 rows because deleted 2 rows.

I want to disable the user Either deleting the rows or saving the workbook.

This is all in BI 7.0..we are in the process of upgrading from BW 3.1 to BI 7.0.

Thanks,

RAM

Re: Problem with Workbooks

Former Member — Fri, 26 Oct 2007 13:25:27 GMT

this all happens in RRMX transaction.

Re: Problem with Workbooks

Former Member — Mon, 29 Oct 2007 15:24:16 GMT

Hello Ram,

acdording to Note 373979 - Authorization for saving roles there is a authorization object S_BDS_D (BC-SRV-KPR-BDS: Authorizations for Accessing Documents). You have to find out, in which role this object is used, and than withdraw some activities.

Regards Wolfrad

Re: Problem with Workbooks

Former Member — Wed, 31 Oct 2007 01:19:18 GMT

Did you check the trace to confirm whether saving a workbook is passing thru an authority- check on S_USER_AGR? You might be on a lower than 09 support stack on SAP_BW. check with sapnote 955715.

Message was edited by:

Keerti Vemulapalli