I have a question about BW access. One of our key concerns is Power User and Reporting Users ability to assign and maintain queries and other objects in Menu and Workbook roles. In BW we have designed two roles that work in conjunction with one another. A Security role to restrict users to InfoAreas, InfoCubes, etc.., and a Menu Role that only has the queries and web reports the user is allowed to execute. These two roles work in conjunction to secure users in BW. If you have time can you answer the question below:
Do you allow users other than Security or Basis assign Queries, Workbooks, Web Reports, or other objects to roles?
Please explain the reasons why this access is granted to users other than security/basis
Explain why this access is not delegated to non-admin users?