cancel
Showing results for 
Search instead for 
Did you mean: 

Permissions in a Query

Former Member
0 Kudos

Hi,

I have a Query created and I want that a user can execute it but only for a selected centers of the company. However, other users have to be able to execute the query without limitations.

How can I do that? (if it's possible)

Thanks,

Oscar

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Oscar,

I hope i m getting your problem right.

You need to sit with your Security/Basis Administrator to achieve the following task.

1. You need to create a role first.

2. Then,in that role goto Maintain Authorization data and Generate Profiles and create profile add the selected centres of that company which ever the user is authorised to view in that Profile.

3. Generate the profile and save it.

4. Add the specific role into your User's role(su01).

5. Also your characteristic has to be "Authorization Relevant"('Business Explorer' Tab in change of of infoObject).

6. At the query level you need to restrict that characteristic with a New variable(This variable type has to be Authorization Variable").

Once done, when the user runs the query it will ask for centres for company and run for those values by which the user has been restricted.

Hope it helps.

Regards,

Parth.

Former Member
0 Kudos

Hi, Partho.

Your reply is very interesting, but at step 5 I've a problem. Where can I the characteristic like 'Authorizartion Relevant'?

Thanks!

Oscar

Former Member
0 Kudos

Hello Oscar,

Why not create a query by copying the base query with restrictions for the particular centers? assign this query to this usr role.

Have the base query assigned to all other users which does not have restrictions for centers.

Hope it helps..

thanks,

Former Member
0 Kudos

Oscar

It is possible using Role concept in authorization ask your BW security consultant and he will create separate roles for each centers

Hope this helps

Thnaks

sat

Former Member
0 Kudos

This user has a different role limiting access to a center, but I've seen that for queries and reports created by me this restriction is not effective automathically.