postgres连接报错 permission denied for relation

create user xiaoming with password '8RUy';
grant all on DATABASE yqxe to xiaoming;
\c mydb (切换到我的数据库yqxe)
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO xiaoming;

参考链接:https://blog.csdn.net/fwhezfwhez/article/details/88854470

posted @ 2020-09-09 17:42  邓旭阳  阅读(1762)  评论(0)    收藏  举报