ERROR: permission denied for relation admin
我用bingo用戶登錄數(shù)據(jù)庫blog，報錯permission denied for relation admin。
原因：bingo沒有blog數(shù)據(jù)庫操作的權(quán)限。
授權(quán)：(注意：需要進(jìn)入到要操作的數(shù)據(jù)庫里進(jìn)行操作)

postgres=# \c blog
You are now connected to database "blog" as user "postgres".
blog=# grant all on database blog to bingo;
GRANT
blog=# grant all privileges on all tables in schema public to bingo;
GRANT