A user might receive the Execute privilege accompanied by the WITH GRANT option authority to grant the Execute privilege to other users. If a user loses the Execute privilege on a routine, the Execute privilege is also revoked from all users to whom that user granted the Execute privilege.
The following example shows an equal() function defined for a UDT and the GRANT statement to enable user mary to execute this variation of the equal() function:
CREATE FUNCTION equal (arg1 udtype1, arg2 udtype1) RETURNING BOOLEAN EXTERNAL NAME "/usr/lib/udtype1/lib/libbtype1.so(udtype1_equal)" LANGUAGE C END FUNCTION; GRANT EXECUTE ON equal(udtype1, udtype1) to mary
User mary does not have permission to execute any other UDR named equal().
For more information, see the GRANT and REVOKE statements in the IBM Informix: Guide to SQL Syntax.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]