RE: Off-Topic: setting field authorities on a physical file ona DB2/400

While I am far from being a Java expert I wish to reply anyway.

Insert and Delete does not work for FIELDS.  One doesn't insert or delete a 
field into a record (or column into a table).  One inserts or deletes the 
entire record.  Thus field level authority would not be appropriate at the 
insert or delete time.  Only when updating or accessing an existing record.  I 
think that is why IBM (in their infinite wisdom) set it up the way they did.


Andy Leisk
Senior Programmer Analyst
Banta Global Turnkey Group
Menasha WI USA
Phone: 920-751-4434




-----Original Message-----
From: Michael Knezevic [mailto:m.knezevic@porta.de]
Sent: Thursday, October 11, 2001 5:26 AM
To: java400-l(a)midrange.com
Subject: Off-Topic: setting field authorities on a physical file on a
DB2/400


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 is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.