KfWiki: Postgresql Roles and Users

Revision [2026]

Last edited on 2008-10-20 22:30:13 by WikiAdmin

Deletions:

~~# check grants with psql -l~~

Revision [2025]

Edited on 2008-10-20 22:29:56 by WikiAdmin

Additions:

GRANT ALL PRIVILEGES ON DATABASE database_name TO role_name WITH GRANT OPTION;
Display grants with **psql -l**
# check 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}

Deletions:

~~GRANT ALL PRIVILEGES ON DATABASE database_name to role_name WITH GRANT OPTION;~~

Revision [2023]

Edited on 2008-10-20 22:12:11 by WikiAdmin

Additions:

GRANT ALL PRIVILEGES ON DATABASE database_name to role_name WITH GRANT OPTION;

Deletions:

~~GRANT ALL PRIVILEGES ON DATABASE database_name to GROUP role_name WITH GRANT OPTION;~~

Revision [2022]

Edited on 2008-10-20 22:09:29 by WikiAdmin

Additions:

GRANT ALL PRIVILEGES ON DATABASE database_name to GROUP role_name WITH GRANT OPTION;

Deletions:

~~grant all on database database_name to role_name with grant option;~~

Revision [2021]

Edited on 2008-10-20 22:07:34 by WikiAdmin

Additions:

==Grant==
grant all on database database_name to role_name with grant option;

Revision [2020]

The oldest known version of this page was created on 2008-10-20 22:05:59 by WikiAdmin