Bw restriction

[Former Member]

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

SR

[Former Member]

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!

[Former Member]

Hi

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.

[Former Member]

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!

[Former Member]

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

SR

RSZCOMPID

RSZCOMPTP

[Former Member]

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

[Former Member]

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