Postgresql 为已有数据库创建数据库用户

Postgresql 创建数据库用户

https://blog.csdn.net/qq_38626589/article/details/108222057?ops_request_misc=&request_id=&biz_id=102&utm_term=postgreSQL%E7%BB%99%E6%95%B0%E6%8D%AE%E5%BA%93%E6%96%B0%E5%BB%BA%E4%B8%80%E4%B8%AA%E7%94%A8%E6%88%B7%EF%BC%8C%E5%8F%AA%E5%8F%AF%E4%BB%A5%E8%BF%9B%E8%A1%8C%E6%9F%A5%E8%AF%A2&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduweb~default-1-108222057.pc_search_result_before_js&spm=1018.2226.3001.4187

Postgres 创建数据库查询用户步骤：
1、postgres进入数据库，创建用户：

create user audit with password 'audit';

2、切换数据库，授权访问schema：
\c database_test

grant usage on schema adempiere to audit;

授权访问表权限：
所有表的查询权限

grant select on all tables in schema adempiere to audit;

au_user表的查询权限

grant select on table adempiere.ad_user to audit;

撤销赋值的权限 \c database_test：

revoke all on all tables in schema adempiere from audit;

revoke all on schema adempiere from audit;

如果访问自增序列，需要授权

grant select,update on all sequences in schema adempiere to audit;

授权访问数据库：

grant connect on database database_test to audit;

撤销访问数据库权限：

revoke all on database database_test from audit;

修改数据库用户密码
psql -U postgres

alter user postgres with password ' ';

alter user adempiere with password ' ';