Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Bw restriction

Former Member
0 Kudos

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

5 REPLIES 5

Former Member
0 Kudos

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.

0 Kudos

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!

0 Kudos

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

0 Kudos

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

0 Kudos

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