Help needed regarding Plant

[Former Member]

Hi Friends,

There are certain users that can view only certain plant e.g. Plant wxc1. If a query doesn't have plant selection screen (query will show result for all plants), user with restricted plant view will not be able to see any result at all when executing the query.

There are many standard queries without plant selection screen. One way is to modify the standard query to have a plant selection screen. However, users may not use all the standard queries. Is there any other way to address this?

Regards

Amarendra

[Former Member · Accepted solution]

Hi Amarendra,

When you say standard queries, do you mean system query? Or user created queries?

Thanks,

Gordon

[Former Member · Accepted solution]

Thanks for the responce.

I mean to say system quries.

regards

Amarendra

[Former Member · Accepted solution]

You can do it by using 'Authotization' screen.

Goto 'Administration -> System Initialization -> Authorizations.

Select a user from the left window and from the right window choose Reports ->Query Generator ->Saved Queries - System' and set the appropriate authorization explained as followingly:

Full Authorization u2013 The user can run system queries. These are queries found in the Query Manager window in the System category.

No Authorization u2013 The user cannot run system queries.