以superUser进入数据库:
psql -U postgres -d postgres
切换到mydb数据库:
\c mydb
//赋予所有表的所有权限给xiaoming
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO xiaoming;
//单独 赋予tuser表的所有权限给wechart用户
GRANT ALL PRIVILEGES ON tuser TO wechart;
如果不知道用户,可以查询所有的用户,然后供参考:
select * from pg_user;
usename | usesysid | usecreatedb | usesuper | userepl | usebypassrls | passwd | valuntil | useconfig
-----------------------------+----------+-------------+----------+---------+--------------+----------+----------+-----------
replicator | 17065 | f | t | t | f | ******** | |
postgres | 10 | t | t | t | t | ******** | |