BW 3.5 authorization

[Former Member]

I want to let the users can only read and excute the reports built by other users. But the owners has the full auth. of the reports built by themselves. Which auth. obj. can I use? And how to set the value of this obj? Thanks.

[Former Member]

I want to let the users can only read and excute the reports built by other users. But the owners has the full auth. of the reports built by themselves. Which auth. obj. can I use? And how to set the value of this obj? Thanks.

[Former Member]

Hi Yimeng,

Use the following reporting objects:

<b>S_RS_COMP</b>

Authorizations for using different components for the query definition. This authorization object is very important for reporting.

Its fields:

Activity: Gave them 03 and 16.

InfoArea: Give the name of Info area

InfoCube: Give the name of the cube on which the Query was built.

Name of reporting component: Give the Query name

Type of reporting component: Reporting users only need REP,which is the ability to execute queries against the InfoCube.

<b>S_RS_COMP1</b>

This object restricts which queries you can see in the reporting tool. You may restrictaccess to queries that are owned by certain users.

It looks similar to S_RS_COMP, only it does not have the InfoArea and

InfoCube fields, but instead has an <b>Owner</b> field. Enter the name of the owner of the query. This would enable them to view their own queries.

Hope it helps.

Please award points if it is useful.

Thanks & regards,

Santosh

[Former Member]

I use this method by using 2 s_rs_comp1:

1. ACTVT: 02,03,06,16; RSZOWNER:$USER

2. ACTVT: 03,06; RSZOWNER:*

This make only the owner of the report can change and delete it. But other users can only display and excute.

But still thanks for your reply. I found this answer on www.sapsecurityonline.com