RE: password politic - Mailing list pgsql-admin

From Miguel Gonzalez
Subject RE: password politic
Date
Msg-id 00f001c0e1e2$b93a0620$fa01a8c0@clientesql
Whole thread Raw
In response to RE: password politic  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-admin
dear all,

 I have been reading through all the documentation about user
authentification and still dont have a clear idea. Let me know
if I am right. By the way, I am using postgreSQL 7.0.3.

In the documentation Ive read that in need to execute in the psql shell the
command inserto into pg_group whenever I want
to add a new group. I used create group instead (why cant I use it??? ) and
checked the table pg_group and got the right result and have an entry for
the new group in that system table. Aftewards I add a user with the create
user command in the psql shell and granted the access permissions with the
"grant" command and added the new user to the group with the command "alter
group mygroup add user new_user". Everything seems to work fine, apart of
the detail that I need to set the password for the postgres user in the
system with the command "alter user". Am I doing everything fine?

 In the pg_hba.conf file Ive got the following entries:

 local        all
crypt
 host         all        127.0.0.1        255.255.255.255          crypt

 Please give some feedback

 Thank you very much in advance

 Miguel







----- Original Message -----
From: Peter Eisentraut <peter_e@gmx.net>
To: Miguel Gonzalez <iafmgc@unileon.es>
Cc: <pgsql-admin@postgresql.org>
Sent: Friday, May 18, 2001 10:04 PM
Subject: RE: [ADMIN] password politic


> Miguel Gonzalez writes:
>
> > thank you for your short reply but it would much more helpful if you
give me
> > any idea of how the password politic works.
>
>
http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/auth-methods.htm
l#AEN13248
>
> --
> Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter
>


pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Script to createuser
Next
From: twanger@smartvia.de
Date:
Subject: simpler query significantly slower