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

password politic

From: "Miguel Gonzalez" <iafmgc(at)unileon(dot)es>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: password politic
Date: 2001-05-18 18:07:14
Message-ID: 01e701c0dfc5$5e86fc70$fa01a8c0@clientesql (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
Dear All,

 I am trying to configure the access to the postgreSQL server through web. I
would like that someone could give
a general idea of how the password politic works in PostgreSQL.

 Let me explain what I have tried so far.

 I want to do access to PostgreSQL using password encryption. What I have
read is that in that case you need to use
the passwd file.

 I tried to use the commands for adding a user to the system (create user or
createuser on the system prompt) but I have
seen that in that case, postgreSQL dont add a entry for the new user in the
passwd file. BUT if I use the command "pg_passwd passwd" and gives the
details for the new user, then it does add the entry to the passwd file, but
not in the pg_pwd file where stores the names of the users of postgreSQL (I
tried to access through the psql command to the database and the user doesnt
exist after only have added using pg_passwd).

 Does this mean that I have to do this two steps?. I am developing an
administration application under C++ Builder and I would like to add users
from that application using SQL, trigger, fuctions or whatever. How can I do
it without doing it manually?

 I hope I have explained myseft clearly.

 Thank you in advance and sorry for my English

 Miguel





In response to

pgsql-admin by date

Next:From: Marek PętlickiDate: 2001-05-18 19:06:31
Subject: Re: Cost limit.
Previous:From: Tom LaneDate: 2001-05-18 17:00:39
Subject: Re: Cost limit.

pgsql-general by date

Next:From: Lamar OwenDate: 2001-05-18 18:13:04
Subject: Re: Postgres problem when compiling C++ in Red Hat 6.2
Previous:From: Dave SmithDate: 2001-05-18 17:32:21
Subject: Vacuum Failed - backend closed the channel unexpectedly

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