I think you’ve all had privileges on database
grant all privileges on database XXX to XXX
is not in use.
and don’t want a table, to assign permissions.
Enter database
psql-u postgres-d postgres
\c mydb // switch TO mydb database
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO xiaoming;
// give ALL PRIVILEGES ON ALL tables TO xiaoming
GRANT ALL PRIVILEGES ON tuser TO wechart;
// gives wechart user, tuser table all permissions