The IFMX_ROLES_WITH_GRANT Environment Variable

The WITH GRANT OPTION keywords of the GRANT statement are valid when privileges are granted to roles only if a new environment variable, IFMX_ROLES_WITH_GRANT, was set in the database server environment before the server started up. Unless this variable is set, the syntax of the GRANT statement is the same as in XPS 8.50, and this feature is disabled.

If privileges are granted to roles using this feature, and the server is subsequently restarted with IFMX_ROLES_WITH_GRANT unset, the feature becomes disabled for privileges subsequently granted to roles. But users who hold roles that were granted access privileges WITH GRANT OPTION continue to hold those roles, and can continue to grant the table access privileges of those roles to other users (but no longer using the WITH GRANT OPTION keywords).