Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Restricting sales org in a query

Go to solution
Former Member

‎12-15-2009 5:54 PM

0 Kudos

Hi,

I've been asked to investigate how to restrict users from accessing different sales orgs in a query report. Is there an easy way? I have looked at the code and found where I can add some authorisation checks on the infocube but that seems a very roundabout way of doing it?

Any ideas?

Thanks,

Gill

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎12-15-2009 6:32 PM

0 Kudos

Hi Gill,

Is this in R/3 or BW? If it's BW is it 3/3.5 or BI7?

3 REPLIES 3

Go to solution
Former Member

‎12-15-2009 6:32 PM

0 Kudos

Hi Gill,

Is this in R/3 or BW? If it's BW is it 3/3.5 or BI7?

Go to solution
Former Member
In response to Former Member

‎12-15-2009 6:33 PM

0 Kudos

Sorry, it's R/3 ECC 6.0

Go to solution
Former Member
In response to Former Member

‎12-15-2009 6:38 PM

0 Kudos

OK, bad news is that auths aren't included in queries unless they are based on a Logical Database & there are checks in the LDB. I suppose this is because query is for quick & dirty reporting.

Good news is that you can restrict but from what you are saying I think you have worked out how to do it already. The only way I am aware of is to add AUTHORITY-CHECK into the record processing part of the infoset code.

Another alternative is to create queries that only select for a particular sales org and only assign those queries to users who need to be restricted.