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
