From: | Prabu Subroto <prabu_subroto(at)yahoo(dot)com> |
---|---|
To: | Postgres General Milis <pgsql-general(at)postgresql(dot)org> |
Subject: | changing the password of postres |
Date: | 2004-09-07 10:59:31 |
Message-ID: | 20040907105931.3818.qmail@web41811.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear my friends...
I am using SuSE 9.1 and postgres 7.2.x .
Each time if I want to connect to postgres with
postgres I do like this:
"
patrixlinux(at)patrix:~> su
Password:
patrix:/localhome/patrixlinux # su postgres
postgres(at)patrix:/localhome/patrixlinux> cd
postgres(at)patrix:~> psql kv
Welcome to psql 7.4.2, the PostgreSQL interactive
terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
kv=#
"
So now, the user "postgres" still has no password.
How can I create the password for the user with psql?
How can I create an account and its password with sql
query from psql? And how can I define that they have
the privilege to work with a database and some
tables....?
Thank you very much in advance.
__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Thomas | 2004-09-07 11:01:10 | Re: postgres 8 performance |
Previous Message | Alex Soto | 2004-09-07 10:48:35 | Help supressing NOTICE messages |