06-28-2008 9:45 AM
Can we restrict queries created by one Super user so that any other super user cannot delete the query.
I understand that we use the object S_RS_COMP1 for query owner but this doesnt seem to work.
Any help would be appreciated.
Thanks,
Yogesh
06-30-2008 6:49 AM
Hi Yogesh,
Try to trace and see what is the error.If your system is 3.5 use tcode RSSM to trace
and RSECADMIN in BI7
You will get the missing object
hope this helps
06-30-2008 6:49 AM
Hi Yogesh,
Try to trace and see what is the error.If your system is 3.5 use tcode RSSM to trace
and RSECADMIN in BI7
You will get the missing object
hope this helps
06-30-2008 8:03 AM
06-30-2008 8:11 AM
Hi Auke,
I have tried restricting access by $user but the issue here is I have multiple power users having the $USER authorization. So if i create a query with one power user the other power user is able to modify the query/ delete.
Can we restrict this somehow.
Thanks,
Yogesh
06-30-2008 8:46 AM
Please check role assigned to power users.
May be they are getting authorizaton from some other role.
hope this helps
06-30-2008 7:29 PM
As Trupti suggested, the access might be coming from other roles. Use a good naming convention for queries in S_RS_COMP & S_RS_COMP1 & it may solve your problem.
07-17-2008 4:43 AM
We tried testing with various combination of $ user with * value for activity and added another S_RS_COMP1 with user as * and activity as 03 and 16. It worked
Still testing it before it can be implemented on the lanscape