Re:

Glen,

If you run an SQL over IPGAMF4/APG55PHY selecting records where the menu =
'menu of your choice' and option = 'option of your choice'.

i.e. select * from ipgamf4/apg55phy where menu55='OEAI' and mopt55
in('**','21')

You will need to use the '**' as this indicates that a user has ALL access
to the menu (Created by using F15 when authorising users to options within
Common Functions).

Hope this helps

Regards
Geoff





                                                                           
             "Glen Boyle"                                                  
             <gboyle@xxxxxxxxx                                             
             .uk>                                                       To 
             Sent by:                  "System 21 Users"                   
             system21-bounces@         <system21@xxxxxxxxxxxx>             
             midrange.com                                               cc 
                                                                           
                                                                   Subject 
             14/07/05 17:37            [SYSTEM21]                          
                                                                           
                                                                           
             Please respond to                                             
              System 21 Users                                              
             <system21@midrang                                             
                  e.com>                                                   
                                                                           
                                                                           




Morning all,

I have had a memory blank and im sure this has been asked before so I
apologise in advance.


I need to be able to report on say all users who have access to certain
menus i.e OEAI option 21 for example.
>From what I can see you cant do this within System21 other than actually
going through each individual user which would be a very long and boring
task.

Would any one be able to point me in the direction of the files so I
could maybe knock up a query ..? Or of course have any better
suggestions.....





Kind Regards
Glen Boyle
Group IT Manager
G.Costa & Co. Limited
Tel: 01622 713318
Fax: 01622 713331
www.gcosta.co.uk <blocked::blocked::blocked::http://www.gcosta.co.uk/>

gboyle@xxxxxxxxxxxx
<blocked::blocked::blocked::mailto:gboyle@xxxxxxxxxxxx>
This communication contains information which is confidential and may
also be privileged. It is for the exclusive use of the intended
recipient(s). If you are not the intended recipient(s) please note that
any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful. If you
have received this communication in error please return it to the
sender.





The views expressed in this email are the views of the individual and may
not reflect the views of the organisation. G Costa & Co Limited accepts no
liability for any losses or damages arising from reliance on the
information contained in this email.The information contained in this email
is confidential, may be legally privileged and is intended solely for use
by the individual or organisation to whom it is addressed.

Email information is subject to copyright and must not be used,
disseminated, copied or disclosed to third parties without the written
consent of G Costa & Co Limited.
If you are not the intended recipient you should delete this email, destroy
all copies and inform the Webmaster (webmaster@xxxxxxxxxxxx).

Copyright G Costa & Co Limited
All Rights Reserved

Registered Office: Weston Centre, 10 Grosvenor Street, London W1K 4QY

This email has been scanned for all viruses by the MessageLabs Email
Security System. For more information on a proactive email security service
working around the clock, around the globe.
Visit http://www.messagelabs.com
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.




--------------------------------------------------------------------------------------------------------------------
*******************Confidentiality and Privilege Notice*******************

This email is intended only to be read or used by the addressee. It is
confidential and may contain legally privileged information. If you are not the
addressee indicated in this message (or responsible for delivery of the message
to such person), you may not copy or deliver this message to anyone, and you
should destroy this message and kindly notify the sender by reply email.
Confidentiality and legal privilege are not waived or lost by reason of mistaken
delivery to you.

Thorn Australia Pty Ltd has implemented anti-virus software and whilst all care
is taken, it is the recipients responsibility to ensure that any attachments are
scanned for viruses prior to use.