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_userOr the following statement for SQL Server:
ALTER SERVER ROLE Deletion_By_Rule ADD MEMBER deletion_userOr this statement for PostgreSQL:
GRANT Deletion_By_Rule TO deletion_userDeletion_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.