09-06-2007 2:49 AM
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
09-06-2007 4:34 AM
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.
09-06-2007 6:22 AM
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!
09-06-2007 10:38 PM
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
09-07-2007 6:31 AM
09-09-2007 6:27 AM