Postgres how to check if user has CREATEDB permissions?

Question

I need to check if a specific user has permissions to create a database in Postgres. How can i accomplish that?

user731136 · Accepted Answer · 2012-10-18 14:51:46Z

7

Try this:

select rolcreatedb
from pg_authid 
where rolname = 'your user name'

answered Oct 18, 2012 at 14:51

user731136

Sign up to request clarification or add additional context in comments.

5 Comments

Asclepius Over a year ago

For the current user, use rolname = current_user.

Daniel Vérité Over a year ago

Use pg_roles instead of pg_authid if you're not superuser.

mfcallahan Over a year ago

What I use to quickly check the permissions on the current role: SELECT * FROM pg_roles WHERE rolname = current_user

jian Over a year ago

yech. pg_roles is public for all. @mfcallahan

user5480949 Over a year ago

Worth noting that rolcreatedb can be false for super users but they can still create a database. Selecting rolcreatedb OR rolsuper should work better

mcalex · Accepted Answer · 2012-10-18 14:24:37Z

1

There are database functions that can do this for you eg:
has_database_privilege(user, database, privilege)

See here: http://www.postgresql.org/docs/8.3/static/functions-info.html for a list of functions and here: http://www.postgresql.org/docs/8.3/static/ddl-priv.html for the privileges to test against.

hth

answered Oct 18, 2012 at 14:24

mcalex

6,7985 gold badges53 silver badges86 bronze badges

2 Comments

Faris Zacina Over a year ago

I don't have a database parameter to provide to that function. I want to check if there is a permission on server level, not db level.

mcalex Over a year ago

This may be the function you are after, then: pg_has_role(user, role, privilege) (from the same page).

Collectives™ on Stack Overflow

Postgres how to check if user has CREATEDB permissions?

2 Answers 2

5 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related