Informix Error -8260: Multiple security policy clauses.

Cause and resolution

Multiple security policy clauses.

The security policy clause has been specified more than once. Either ADD or DROP SECURITY POLICY was specified more than once or a combination of ADD and DROP SECUIRTY POLICY was specified. Change the statement to so that it has only one ADD or DROP SECURITY POLICY clause.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-8260 fires when an ALTER TABLE statement has more than one security-policy clause — per the official guidance.

ADD SECURITY POLICY (or DROP SECURITY POLICY) specified more than once, per the official guidance — the first named case.
Both ADD and DROP SECURITY POLICY specified in the same statement, per the official guidance — the second named case.

Solutions / Resolution

Change the statement to have only one ADD or DROP SECURITY POLICY clause, per the official guidance.

Examples

Combining ADD and DROP SECURITY POLICY

ALTER TABLE orders ADD SECURITY POLICY p1, DROP SECURITY POLICY p2;
-- -8260: only one security policy clause is allowed

Corrected

ALTER TABLE orders DROP SECURITY POLICY p2;

Diagnostic Checks

Check the ALTER TABLE statement for more than one security-policy clause, and reduce it to a single ADD or DROP.

Related Errors / Related Topics

-8239 — "The table already has a security policy." A related security-policy restriction, about only one policy being associated with a table, rather than multiple clauses in one statement.

An ALTER TABLE statement has more than one security-policy clause — reduce it to one.