Language-level privileges needed for creating

The language-level Usage privilege controls the ability to write a UDR in a particular UDR language. This privilege needs to be granted by user informix or by another user who has been granted the DBA privilege with the WITH GRANT OPTION.

UDR languages have the following GRANT and REVOKE requirements for the Usage privilege:
  • The DBA can grant or revoke the Usage privilege to the SPL language.
  • Another user can grant the Usage privilege if the DBA applied the WITH GRANT keywords in the GRANT EXECUTE ON statement.
The following REVOKE statement revokes Usage privilege on SPL UDRs to a user named dorian: 
REVOKE USAGE ON LANGUAGE SPL TO dorian
By default, the database server:
  • Does not grant Usage privilege on external languages to PUBLIC
  • Grants Usage privilege on SPL, C, and Java™ to PUBLIC

For more information, see the description of privileges in the HCL OneDB™ Database Design and Implementation Guide and the descriptions of the GRANT and REVOKE statements in the HCL OneDB Guide to SQL: Syntax