×

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.




hi,

i know this is a bit off topic, but i hope you can help me.

i'm trying to set authorities (update, insert, delete) for specific fields 
(columns) of a physical file. but the only way i found in IBM's information 
center (book: SC41-5612-02) was via a sql statement (like GRANT UPDATE(field 
[,field,...]) on library/file to user ). the problem is: this only works with 
UPDATE and not with INSERT or DELETE. i know that i could limit the access to 
the physical file by a logical file by one selecting the specific columns but 
that is not what i wanted. my goal was to write a GUI for that in java (mostly 
to get into the java thing connecting to the as400).

my question: is there any other way to set some authorities on the fields of a 
file on the DB2/400 (perhaps in the DDS of the physical file)?

thanx in advance


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.