[SYSTEM21] object authority

[Mona Ferriols <mon.ferriols@xxxxxxxxxxxxxx>]

We do a lot of data downloading to file here. To save on storage we use 1
generic outfile that is saved in QGPL, and that in turn is downloaded by
users. My problem is, Whenever a user runs a query, his authority for the
file becomes *all and PUBLIC becomes *change. If a second user runs another
query using the same outfile, he gets a message saying he's not authorized
to use the file. If i grant him *all authority to the file, the next user
after him experiences the same error. I've also used GRTOBJAUT command but
no dice

Mon Ferriols 
Data Management and Control
Ionics EMS, Inc. Plant 7
Tel: (049) 545-9751
Email: mon.ferriols@xxxxxxxxxxxxxx
Web: www.ionicsgroup.com

"ERP is not just computers and software, but PEOPLE, PROCESSES and
FUNCTIONS."


###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.F-Secure.com/