Postgres 創(chuàng)建Role并賦予權限的操作

CREATE USER role_name> PASSWORD 'role_password>';

GRANT ALL ON DATABASE db_name> TO role_name>;

GRANT SELECT ON ALL TABLES IN SCHEMA schema_name> TO role_name>;

SELECT * FROM information_schema.role_table_grants;

CREATE ROLE name;

DROP ROLE name;

CREATE USER name;
dropuser name;

SELECT rolname FROM pg_roles;

psql -U name;

CREATE ROLE name [ [ WITH ] option [ ... ] ]
where option can be:
SUPERUSER | NOSUPERUSER
| CREATEDB | NOCREATEDB
| CREATEROLE | NOCREATEROLE
| CREATEUSER | NOCREATEUSER
| INHERIT | NOINHERIT
| LOGIN | NOLOGIN
| REPLICATION | NOREPLICATION
| CONNECTION LIMIT connlimit
| [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
| VALID UNTIL 'timestamp'
| IN ROLE role_name [, ...]
| IN GROUP role_name [, ...]
| ROLE role_name [, ...]
| ADMIN role_name [, ...]
| USER role_name [, ...]
| SYSID uid

CREATE ROLE name LOGIN;
CREATE USER name;

CREATE ROLE name SUPERUSER;

CREATE ROLE name CREATEDB;

CREATE ROLE name CREATEROLE;

CREATE ROLE name REPLICATION LOGIN;

CREATE ROLE name PASSWORD 'string';

ALTER ROLE name SET enable_indexscan TO off;

GRANT group_role TO role1, ... ;
REVOKE group_role FROM role1, ... ;