Postgres solves permission denied for relation

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


Read More: