Updating deleting predicates oracle Webcan chat room

12-Sep-2016 19:14

By using a block predicate you can define rules that identify which rows a database user is not allowed to perform an INSERT, UPDATE, or DELETE operation against.

The block predicate is defined using the new CREATE SECURITY POLICY statement introduced in SQL Server 2016.

The block predicate covers both UPDATE, INSERT, and DELETE statements.

These block predicates can be executed before or after the update statement.

updating deleting predicates oracle-74

Broadcast naked chat

To demonstrate why a block predicate is important when implementing RLS security, let me identify a business problem and then demonstrate how to solve the problem by implementing a block predicate.

In our data, the only unique identifier for cx_pets is id.