Authorization to delete by rule

The deletion-by-rule capability is enabled by the i2 Analyze Information Store deployment. By default the database user who deploys the Information Store is authorized to delete by rule.

Authorization to delete by rule includes permission to access and run all of the views and procedures for doing so in the IS_Public schema. For more information, see Deletion views and columns and Functions and stored procedures. If you do not have this authorization, you can see but not access or run these views and procedures.

The authorization to delete by rule can be granted to other users. You can create a new database user and assign the Deletion_By_Rule role to that user, or you can assign the role to an existing user.

For example, you can run the following statement for Db2:

GRANT ROLE Deletion_By_Rule TO USER deletion_user

Or the following statement for SQL Server:

ALTER SERVER ROLE Deletion_By_Rule ADD MEMBER deletion_user

Or this statement for PostgreSQL:

GRANT Deletion_By_Rule TO deletion_user

CAUTION: Assign the Deletion_By_Rule role only to users with sufficient knowledge and authority. Exercise caution when you create deletion rules as they constitute a powerful mechanism for deletion of data that cannot be recovered afterward.