Re: create user

#1

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:

Quote:

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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: create user

comp.databases.postgresql.novice comp.databases.postgresql.novice

Re: create user - 03-31-2004 , 07:20 PM