Revoking exemptions
The REVOKE EXEMPTION statement revokes from a user an exemption on one or more access rules of a security policy.
You must hold the DBSECADM role to revoke exemptions.
Revoke an exemption by issuing the REVOKE EXEMPTION statement,
as described in the HCL
Informix® Guide to SQL: Syntax.
The following statement revokes from user maria an exemption from the IDSLBACWRITETREE rule in security policy company:
REVOKE EXEMPTION ON RULE IDSLBACWRITETREE FOR company FROM mariaTo revoke all IDSLBACRULES exemptions that a user has for
a security policy, specify ALL in place of
the policy name in the statement.