BEX Query Authorizations

We are have authorization issues with Querries. We have created a generic
Role that has some Standard Query's for our Company attached to this Role.
We give access to this role to our user community. The problem we are
having is that the users can Execute the querries and what they are suppose
to do is only Save the Workbook to there favorites. We are running across
a problem because some of the users are saving the workbook as existing
workbook. So when they do this it wipes out the Query in that Role. How
can I stop users from overlaying the MASTER Query. There has to be a way
that you can protect a query so that it cannot be changed. Because we
have generic querries that are being used throughout our company, I need to
be able to protect the query so that it can only be saved to users
Favorites.

-----Reply Message-----
Subject: RE: BEX Query Authorizations

We would appreciate anyones input that could help us with this authorization
issue that we are having. Maybe if we could get input as to how other
Companies are handling there workbooks. There has to be a company that is
having the same problems with Workbooks being overwritten.

Any input would help

-----Reply Message-----
Subject: RE: BEX Query Authorizations

Hi,

Unfortunately I haven't managed to restrict access
to workbook depending on its menu location.

Hey gurus, it would be great to know any more ideas...

Best Regards,

-----Reply Message-----
Subject: RE: BEX Query Authorizations

Hi,

We tried changing the role and are unable to overly the generic role. But
we're unable to save a workbook to our favorites. Any ideas??

-----Reply Message-----
Subject: RE: BEX Query Authorizations

Hello,

Go to role maintenance (PFCG) -> Authorization ->
Chanhe Authorization Data.

Open Basis - General Functions -> BC-SRV-KPR-BDS
and restrict the user activities set like
"Display, Print, Retrieve from Archive, Determine, Assign".

User with appropriate role could not be able to overwrite
WORKBOOKS (!!!).

As for QUERIES, address to
Business Information Warehouse -> BEx - Components
and restrict Activities retaled to Queries -
then users with appropriate role could not be able to
overwrite GLOBAL DEFINITION of QUERY (!!!).

So, you can see, you need to restrict access to queries and
workbooks separately.

Best Regards,