Issue about queries and BW Roles

[former_member726451]

Hi all,

I have a issue about BW queries and roles. I go to explain my issue with a example:

I have a unique role ZBW_ROL. This role has 3 queries, i.e.: ZQ1, ZQ2 and ZQ3. The role is assigned to the users USER1 and USER2, but I want to filter the access to query ZQ3 only for user USER2:

- USER1 only acces to queries ZQ1 and ZQ2

- USER2 access to three queries

Please, how can I do it with unique role? what authorization objects in PFCG t-code must I use?

thanks in advance

best regards

[former_member182470 · Accepted solution]

I think you cannot achieve this with a unique role.

You need to create two separate roles.

Role1: Q1, Q2 has to be assigned to User1

Role2: Q1,Q2,Q3 has to be assigned to User2

Regards,

Suman

[former_member726451 · Accepted solution]

Hi all,

Ok, You are rigth. I haven't got this functionality ussing only one role but I wanted to know the opinion of other BW experts.

Thanks

regards,

[Former Member]

Hi David,

As suggested by suman above, This can be achieved using two roles only.

Regards,

Saurabh Ojha