authz: simplify PermsStore with intarray

Created by: unknwon

Our permissions storage format in Postgres has been transitioned from roaring bitmap (BYTEA) to intarray ([]INT), it is now possible to perform many operations directly using SQLs.

I rely on our tests to ensure correctness, and tested end-to-end.

Easier to be reviewed with split view

Fixes #11768 (closed)