pg_acm is a collection of tools for access control management.
I encourage everyone interested to try it, and if you find it useful, please help me to advocated to add this functionality to Postgres!
- If you are creating a new database:
create role mydb_owner; ---or any other name
create database mydb; -- or any other name
alter database mydb owner to mydb_owner;-
Clone this repo
-
Connect to
mydbas a superuser (postgres) and switch to thepg_acmdirectory -
Run
_load_all.sql -
Invoke
pg_acmby running as a superuser:
SELECT * FROM acm_tools.enable_security();For detailed functionality description, please refer to the User Manual.