In this recipe, you'll learn to create command rules. A command rule defines a protected database operation on a specific database object (for example, UPDATE
on all tables in HR
schema). The evaluation of associated rule set determines if statement will be allowed (executed) or blocked.
Create a command rule by following these steps depicted in Figures 19 and 20.
In the Command field, write UPDATE
; in the Applicable Object Owner field, write OE
; in the Applicable Object Name field, write ORDERS
; and select Disabled for Rule Set (see Figure 20).