Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Re: User names cannot contain `-'

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: John Goerzen <jgoerzen(at)complete(dot)org>
Cc: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Re: User names cannot contain `-'
Date: 1998-04-28 12:35:29
Message-ID: Pine.NEB.3.95.980428083446.6639C-100000@hub.org (view raw or flat)
Thread:
Lists: pgsql-hackers
On 27 Apr 1998, John Goerzen wrote:

> "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> writes:
> 
> > I have a bug reported on the Debian package of 6.3.2:
> > 
> >  > videotapes=> grant all on tapes to www-data;
> >  > ERROR:  aclparse: non-existent user "www"
> > 
> > It is, in fact, impossible to create the user www-data:
> > 
> >   template1=> create user www-data;
> >   ERROR:  parser: parse error at or near "-"
> >   template1=> create user 'www-data';
> >   ERROR:  parser: parse error at or near "'"
> 
> I believe createuser program did that for me (either that or it was
> preinstalled; I don't recall.)  I did not issue a direct SQL command
> to do it, so I think it is likely that createuser did it.
> 
> In any case:
> 
> 
> template1=> select usename, usesysid, valuntil from pg_shadow;
> usename |usesysid|valuntil                    
> --------+--------+----------------------------
> postgres|      31|Sat Jan 31 00:00:00 2037 CST
> www-data|      33|Sat Jan 31 00:00:00 2037 CST
> jgoerzen|    1000|Sat Jan 31 00:00:00 2037 CST
> (3 rows)

	This might have already been gone over, but if this was an upgrade
from a previous release, its possible that this was created with a
'dump/reload'?



In response to

pgsql-hackers by date

Next:From: Thomas G. LockhartDate: 1998-04-28 12:38:29
Subject: Re: [HACKERS] Re: Bug#21681: postgresql: Doesn't allow granting to www-data
Previous:From: Robert HiltibidalDate: 1998-04-28 12:15:53
Subject: Re: [QUESTIONS] Postgres still dying on insert

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group