The where clause on a grant update command combines with the end user’s where clause to qualify the rows to be deleted. This example grants permission for Bob to delete sales data:
grant delete on employee where edept = ‘sales’ to Bob
Now when Bob runs this statement:
delete employee where status = 'terminated'
Adaptive Server runs the statement internally as:
delete employee where status = 'terminated' and edept = ‘sales’