| From: | Vince Vielhaber <vev(at)michvhf(dot)com> |
|---|---|
| To: | <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | create user problem |
| Date: | 2001-06-13 17:16:18 |
| Message-ID: | Pine.BSF.4.30.0106131312320.96641-100000@paprika.michvhf.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
According to \h create user I can stipulate NOCREATEDB and NOCREATEUSER
when I create a user. But I get this:
mydb=# create user foo NOCREATEUSER NOCREATEDB in group bar;
ERROR: parser: parse error at or near "NOCREATEDB"
mydb=#
I can create the user by only stipulating one of the NOCREATE items but
not both. Does that mean something's broke or am I misunderstanding
this:
CREATE USER username
[ WITH
[ SYSID uid ]
[ PASSWORD 'password' ] ]
[ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]
[ IN GROUP groupname [, ...] ]
[ VALID UNTIL 'abstime' ]
This line:
[ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]
does say I can do both, right?
Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com http://www.pop4.net
56K Nationwide Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-06-13 17:16:51 | Re: Australian timezone configure option |
| Previous Message | mlw | 2001-06-13 17:07:04 | Re: Re: Improving pg_hba.conf |