Postgres Pro
Downloads
Home   >   mailing lists

Re: Creating new user in vers 7.02 and pgaccess - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Creating new user in vers 7.02 and pgaccess
Date
Msg-id Pine.GSO.4.02A.10005261449320.12244-100000@Falk.DoCS.UU.SE
Whole thread Raw
In response to Creating new user in vers 7.02 and pgaccess  (Bill Barnes <bbarnes@operamail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Shaw Terwilliger
Date:
Subject: Re: What distribution?
Next
From: CB
Date:
Subject: query string too long??