File Permissions on Jar Files

Aftersqlj.install_jar( ) installs a JAR file in the database and declares a JAR ID for the file, Informix® can access that JAR file only if the user who installed the Informix® instance (typically, user 'informix') has permission to read the directory where the JAR file resides. On UNIX™ systems, for example, this implies that an attempt to read a JAR file that has 600 permissions fails with a FILENOTFOUND exception. The same operation can succeed, however, after the chmod utility sets the permissions to 660 (rw-rw----).

You must hold the Resource privilege or the DBA privilege on the database, and also hold the Usage privilege on the Java™ language, before you can create or drop a Java™ UDR.