topic Bw restriction in Application Development and Automation Discussions

Bw restriction

Former Member — Thu, 06 Sep 2007 01:49:53 GMT

i need to restrict a user to run only queries wich starts with z.

user with query display role is there for him, he has to view / display only queries wich starts with Z... how to restirct ? in wich object is it s_rs_comp/ comp1 ? already restricted in infocube level in s_rs_comp .

please help.

Thanks

Re: Bw restriction

Former Member — Thu, 06 Sep 2007 03:34:18 GMT

S_RS_COMPou can also r

it restricts if someone can create,changr or execute queries.

You can also restrict based on info area,info cube.

you can mention activity 16(execute) and 03(display).

Specify query technical name : z...

S_RS_COMP1

limit the list of queries by the query owner.

Re: Bw restriction

Former Member — Thu, 06 Sep 2007 05:22:26 GMT

pls llok at this requirement again.

best practice is to restrict on infoprofider level and not below that, in real live, restriction at lower level leads to a lot of manitenance after go-live!

Re: Bw restriction

Former Member — Thu, 06 Sep 2007 21:38:09 GMT

Auke, Sri..

already restricted at infocube level in s_rs_comp . my question is how to restrict him ? ... he should only able to create a query with Z. in

s_rs_comp1 .. theere are four fileds... which field and where should i specify Z.

IN S_RS_COMP following are the fields..

ACTVT

RSZCOMPID

RSZCOMPTP

RSZOWNER

RSINFOAREA

RSINFOCUBE

restricted infocube at RSINFOCUBE field .. if i want him to restrict while creating query which starts with Z. which filed and where should i specify Z. he should able to create quesries with only Z names. hope it is clear now. please help

RSZCOMPID

RSZCOMPTP

Re: Bw restriction

Former Member — Fri, 07 Sep 2007 05:31:52 GMT

use RSZCOMPID valeu Z* and activity 1,2,3

Re: Bw restriction

Former Member — Sun, 09 Sep 2007 05:27:58 GMT

Go with RSZCOMPID Z* and choose activity 1(create).