10-25-2007 8:52 PM
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
10-31-2007 1:19 AM
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
10-26-2007 11:38 AM
Hello Ram,
could you please give more information which application you are talking of. Which transaction ?
regards Wolfrad
10-26-2007 2:23 PM
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
10-26-2007 2:25 PM
10-29-2007 3:24 PM
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
10-31-2007 1:19 AM
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