alter user test set default_transaction_read_only=on;
grant all on database crm_db to test;
grant select on all tables in schema public to test; // 起作用的是这句 要进入crm_db 操作,在那个db环境执行就授哪个db的权
删除前撤销
revoke all on database crm_prod_myl from test;
revoke select on all tables in schema public from test;
grant all on database crm_db to test;
grant select on all tables in schema public to test; // 起作用的是这句 要进入crm_db 操作,在那个db环境执行就授哪个db的权
删除前撤销
revoke all on database crm_prod_myl from test;
revoke select on all tables in schema public from test;
