{{parent page="Postgresql"}}

===Postgresql Roles and Users===

==Show roles==
%%
select rolname from pg_roles;
%%

==Role==
%%
create role role_name;
drop role role_name;
grant role_name to user_name;
revole role_name from user_name;
%%

==Grant==
%%
GRANT ALL PRIVILEGES ON DATABASE database_name TO role_name WITH GRANT OPTION;
%%

Display grants with **psql -l**
%%
List of databases
Name | Owner | Encoding | Access Privileges
-----------+----------+----------+-----------------------------------------------------------
d2 | ken | UTF8 | {=Tc/ken,ken=CTc/ken,dbo=C*T*c*/ken}
%%