File Permissions on Jar Files

Aftersqlj.install_jar( ) installs a JAR file in the database and declares a JAR ID for the file, HCL OneDB™ can access that JAR file only if the user who installed the HCL OneDB 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.