# AZ105: A rule written wrongly

Under `rules schema.table`, each line is a command and an expression: `select : view`, `insert : edit`, `update : edit`, `delete : owner`. Only update rules name columns or say when they are checked: `update owner_id : share` (who may change that column), `update after : edit` (checked on the row after the change). A plain `update` rule is checked on the row before and after the change, so `update before :` is refused. A column named `before` or `after` says when it is checked: `update after after : edit`. Masks are `mask col1, col2 : expression`. A foreign key whose action is meant is `cascade from schema.table`, or `cascade from schema.table (column, ...)`, each column named once.

Reported when the policy is compiled: `rowstile check`, the editor, `rowstile dev`.

## The mistake

```authz
app role app_user
type user = app.users
type folder = app.folders
  owner : user = owner_id
  can edit = owner
rules app.folders
  select owner_id : edit
```

```
line 7: only update rules can name columns, 'before' or 'after' (got: select owner_id) [AZ105]
```

## Fixed

```authz
app role app_user
type user = app.users
type folder = app.folders
  owner : user = owner_id
  can edit = owner
rules app.folders
  select : edit
  update : edit
  update owner_id : edit
```
