Granting exemptions

The GRANT EXEMPTION statement gives a user an exemption from one or more access rules of a security policy.

You must hold the DBSECADM role to grant exemptions.

Grant an exemption by issuing the GRANT EXEMPTION statement, as described in the HCL Informix® Guide to SQL: Syntax.

The following statement grants user maria an exemption from the IDSLBACWRITETREE rule in security policy company:

GRANT EXEMPTION
ON RULE IDSLBACWRITETREE
FOR company
TO maria

To grant a user exemptions from all IDSLBACRULES of a security policy, specify ALL in place of the policy name in the statement. Typically, this type of exemption is practical for a user who is responsible for loading and unloading data in protected tables.