Thread: Creating new user in vers 7.02 and pgaccess

Hello the List:

Connected to template1 as user 'postgres'.
Creating a new user reported an error in SQL parsing.
Found that I could create a new user by omitting any password.
Was able to edit that new user to super user privileges.
Attempting to add a password again reported the query parsing error.

Can login to template1 with the non-passworded new user.

Thanks for your help.

Bill Barnes

------------------------------------------------------------
This e-mail has been sent to  you  courtesy of OperaMail,  a
free  web-based  service  from  Opera  Software,  makers  of
the award-winning Web Browser - http://www.operasoftware.com
------------------------------------------------------------

On Fri, 26 May 2000, Bill Barnes wrote:

> Connected to template1 as user 'postgres'.
> Creating a new user reported an error in SQL parsing.
> Found that I could create a new user by omitting any password.
> Was able to edit that new user to super user privileges.
> Attempting to add a password again reported the query parsing error.

You need to write CREATE USER name WITH PASSWORD 'password here'. Note the
single quotes, that has changed. pgaccess hasn't caught up with that yet
but it will be okay in the 7.0.1 release.


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden