数据库教程: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, ... ;