Example 10 : Delete clear | view source | main page | next example
The NextDB security policy for deleting data is the same as updates. In order to execute a delete, you need to have first retrieved a temporary encrypted key for the row you want to delete. In other words you must first query for the row, and then you supply the encrypted row id back with the delete. The second aspect of this security policy is that the query that is used to initially get the row id must have "FOR DELETE" enabled. In other words, some queries are read only, while others can allow either "FOR UPDATE" and/or "FOR DELETE". Batch deletes are not allowed, and row level security is enabled at the query level with the "FOR DELETE" flag.