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