Re: create user

hi,

sorry, but it works for me just cut and pasting

dba=# CREATE USER janos WITH SYSID 801 PASSWORD 'netuddmi' CREATEDB
dba-# ;
CREATE USER
dba=# \du
List of database users
User name | User ID | Attributes
-----------+---------+----------------------------

.....

janos | 801 | create database

...

(17 rows)

dba=#

On Wed, Mar 31, 2004 at 03:07:57PM -0500, János wrote:
> test-# \du
> List of database users
> User name | User ID | Attributes
> -----------+---------+----------------------------
> postgres | 1 | superuser, create database
> (1 row)
>
> test-# \h create user
> Command: CREATE USER
> Description: define a new database user account
> Syntax:
> CREATE USER name [ [ WITH ] option [ ... ] ]
>
> where option can be:
>
> SYSID uid
> | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
> | CREATEDB | NOCREATEDB
> | CREATEUSER | NOCREATEUSER
> | IN GROUP groupname [, ...]
> | VALID UNTIL 'abstime'
>
> test-# CREATE USER janos WITH SYSID 501 PASSWORD 'netuddmi' CREATEDB
> CREATEUSER
> test-# \du
> List of database users
> User name | User ID | Attributes
> -----------+---------+----------------------------
> postgres | 1 | superuser, create database
> (1 row)
>
>
> What am I doing wrong ?
>
> János
> -----------------------------------------------------
> So, while openness provides a couple of security advantages in itself,
> the chief reason why Linux and BSD offer superior security is not so
> much because they're open source, but because they're not Windows.
> http://www.theregister.co.uk/content/55/36029.html
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
joe speigle
www.sirfsup.com