Postgres 创建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, ... ;