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@postgresql.org)

--
joe speigle
www.sirfsup.com