Dynamic Server allows users to create UDRs in stored procedure language (SPL) and the C and Java languages. To create a UDR, a user must have RESOURCE privileges in the database. In addition, to create a UDR in the C or Java language, a user must also have Usage privileges on those languages.
By default, language usage privileges for UDRs are granted to user informix and users with the DBA privilege. However, only user informix can grant language usage privileges to other users. Users with the DBA privilege have language usage privileges, but cannot grant these privileges to other users.
The following statement shows how user informix might grant the users mays, jones, and freeman permission to create a UDR in C:
GRANT USAGE ON LANGUAGE C TO mays, jones, freeman
Usage privileges for SPL routines is granted to public by default.
Suppose the default Usage privileges on an SPL routine have been revoked from PUBLIC. The following statement shows how a user with the DBA privilege might grant Usage privileges on an SPL routine to users franklin, reeves, and wilson:
GRANT USAGE ON LANGUAGE SPL TO franklin, reeves, wilson