Re: changing the password of postres

Dear Gunduz....

It's solved now. Thank you very much for your help.

But I still have one question...

How can I grant privilege to a user on all tables
under a database.

for example the database name is "kv".
What I need is something like this:
"
create user sven with password 'his_password';
grant all on kv.* to sven;
"

Please tell me.

Thank you very much.
--- Devrim GUNDUZ <devrim@gunduz.org> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> Hi,
>
> On Tue, 7 Sep 2004, Prabu Subroto wrote:
>
> > Each time if I want to connect to postgres with
> > postgres I do like this:
> > "
> > patrixlinux@patrix:~> su
> > Password:
> > patrix:/localhome/patrixlinux # su postgres
> > postgres@patrix:/localhome/patrixlinux> cd
> > postgres@patrix:~> psql kv
> > Welcome to psql 7.4.2, the PostgreSQL interactive
> > terminal.
>
> Or you could run this command with "any" user
> without su:
>
> # psql kv -U postgres
>
> > So now, the user "postgres" still has no password.
> > How can I create the password for the user with
> psql?
>
> ALTER USER will do it.
>
> ALTER USER postgres WITH ENCRYPTED PASSWORD
> 'yourpassword';
> (Don't forget the quotes...)
>
> Also, you must enable password auth:
>
>
http://www.postgresql.org/docs/current/static/client-authentication.html
>
http://www.postgresql.org/docs/current/static/client-authentication.html#EXAMPLE-PG-HBA.CONF
>
> Then reload postgresql...
>
> > How can I create an account and its password with
> sql
> > query from psql?
>
> CREATE USER username WITH ENCRYPTED PASSWORD
> 'yourpassword';
>
> See \h CREATE USER in psql for details.
>
> > And how can I define that they have
> > the privilege to work with a database and some
> > tables....?
>
> See the SQL keyword GRANT .
>
>
http://www.postgresql.org/docs/7.4/static/sql-grant.html
>
> Regards,
> - --
> Devrim GUNDUZ
> devrim~gunduz.org                devrim.gunduz~linux.org.tr
>              http://www.tdmsoft.com
>              http://www.gunduz.org
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (GNU/Linux)
>
>
iD8DBQFBPZaFtl86P3SPfQ4RAoPXAJsGtWfePMGM6TwQNxHMJNGO/kd81wCfcyiA
> KTiehpw329znOng2CgteNc0=
> =zOVs
> -----END PGP SIGNATURE-----
>




__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail