Postgres Pro
Downloads
Home   >   mailing lists

Re: CREATE USER system privilege? - Mailing list pgsql-admin

From Tom Lane
Subject Re: CREATE USER system privilege?
Date
Msg-id 15986.1072106106@sss.pgh.pa.us
Whole thread Raw
In response to CREATE USER system privilege?  (Oli Sennhauser <oli.sennhauser@bluewin.ch>)
Responses Re: CREATE USER system privilege?  (Oli Sennhauser <oli.sennhauser@bluewin.ch>)
List pgsql-admin
Tree view 
Oli Sennhauser <oli.sennhauser@bluewin.ch> writes:
> I wanted to create a user who can create other users.

That is a superuser.

> --> Why does CREATE USER $1 fail???

You need to use EXECUTE to construct this query as a string.
Utility statements in general don't handle parameters.

            regards, tom lane

pgsql-admin by date:

Previous
From: Oli Sennhauser
Date:
Subject: Opinion wanted: Default select rights for users via public schema
Next
From: Tom Lane
Date:
Subject: Re: Opinion wanted: Default select rights for users via public schema