create user

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