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:
- Android has applied for permission and still prompts open failed: eacces (permission denied)
- Solve the problem of dynamically applying for permission, but still reporting an error of open failed: eacces (permission denied)
- Permission error: [errno 13] permission denied: ‘… ” xxx.pyd ‘
- Git error: no permission remote: error: unable to unlink old ‘ README.md ‘ (Permission denied)
- [PostgreSQL tutorial] · PostgreSQL error prompt: “error 42501” or “permission denied”
- “Permission denied” error in Oracle10g installation
- Solutions for permission denied
- Solution to permission denied
- Ioerror: [errno 13] permission denied
- Beeline connection hive2 reports an error permission denied
- cifs mount error(13): Permission denied
- error: cannot open .git/FETCH_ Head: permission denied resolved
- Unhandled rejection Error: EACCES: permission denied
- Monkey stress test (4)-adb opendir failed, Permission denied solution
- NPM ERR! Error: EACCES: permission denied, access ‘/usr/local/lib/node_modules’
- Python error: permissionerror: [errno 13] permission denied solution details
- failed (13: Permission denied) while reading upstream [How to Solve]
- pip install – PermissionError: [Errno 13] Permission denied
- Unhandled rejection Error: EACCES: permission denied, open ‘/Users
- [git] report error and solve cannot open.git/fetch_ HEAD: Permission denied