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:
- [MySQL] [serialize] [error record] after modifying data, no data will be returned (in fact, MySQL does not support it)
- MySQL skip grant tables add user error 1290
- Using Navicat + premium + 11.1 to connect to PG12 version, error: column c.relhasoids does not exist
- MYSQL login error: mysqladmin: connect to server at’localhost’ failed
- 【Linux】psql: FATAL: Ident authentication failed for user “username” Error and Solution
- How can Oracle query tables of other users without adding a table user name
- ERROR 1406 (22001): Data Too Long, field len 30, data len 48
- Error 1045 (28000): access denied for user ‘root’ @’localhost ‘(using password: no)
- Solution to MySQL Error 1130 problem
- MySQL error — multiple methods of failed to find valid data directory and MySQL setting password appear
- Host is not allowed to connect to this MySQL server
- Export and import method of MySQL under Linux
- An error occurred during win10 PostgreSQL installation: “failed to load SQL modules into the database cluster“
- “Permission denied” error in Oracle10g installation
- mysql ERROR 1050 (42S01): Table already exists
- Ctfhub error injection
- MySQL local connection Error 1130_ The solution of MySQL 1130 error report when remote connection through Navicat for MySQL
- What is the schema in the database?
- MySQL forgot the root password
- MySQL password setting error message: error 1054 (42s22): unknown column ‘password’ in ‘field list’