SPL routines
By default, language usage privilege on SPL is granted to user informix and to users who hold the DBA privilege. Only user informix, however, can grant language usage privileges to other users. Users with the DBA privilege hold language usage privileges, but cannot grant these privileges to other users. Usage privilege to create SPL routines is granted to PUBLIC by default.
The following statement shows how user informix might revoke
from PUBLIC but grant to users mays, jones, and freeman permission
to create UDRs in SPL:
REVOKE USAGE ON LANGUAGE SPL FROM PUBLIC
GRANT USAGE ON LANGUAGE SPL TO mays, jones, freemanSuppose 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 privilege to register SPL routines
to users franklin, reeves, and wilson:
GRANT USAGE ON LANGUAGE SPL TO franklin, reeves, wilson