Skip site navigation (1) Skip section navigation (2)

Re: create user

From: joseph speigle <joe(dot)speigle(at)jklh(dot)us>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: create user
Date: 2004-04-01 00:20:19
Message-ID: 20040401002019.GA17106@www.sirfsup.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

pgsql-novice by date

Next:From: BenjaminDate: 2004-04-01 14:49:33
Subject: multiple statements.. and locking
Previous:From: Stephan SzaboDate: 2004-03-31 21:48:44
Subject: Re: create user

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group