Postgres数据库配置用户读写权限（read_write）和只读权限(read_only):

**

Postgres数据库配置用户读写权限（read_write）和只读权限(read_only):

**

（1）读写权限gdxx

CREATE ROLE gdxx WITH LOGIN PASSWORD 'Ka888888';
GRANT CONNECT ON DATABASE postgis_sample TO gdxx;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO gdxx;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO gdxx;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA public TO gdxx;
ALTER DEFAULT PRIVILEGES FOR USER gdxx GRANT ALL PRIVILEGES ON TABLES TO gdx;
ALTER DEFAULT PRIVILEGES FOR USER gdxx GRANT ALL PRIVILEGES ON SEQUENCES