From: DEV <dev@umpa-us.com>
To: pgsql-general@postgresql.org
Subject: Database users Passwords
Date: Tue, 17 Oct 2006 10:41:56 -0400
Message-ID: <002c01c6f1fa$652d3f60$0b01a8c0@LT003> (raw)
Hello all,
I have user information in a table that I want to use to add users to
the user roles tables that are part of postgresql. My question is this: the
passwords in my user table are in there as a text file with the data being
encrypted using the crypt function, is there a way I can use this crypt
password when I do a "CREATE ROLE userid LOGIN PASSWORD 'crypt password'
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE" I know that in the current
CREATE ROLE I have listed will take a clear text password and encrypt it for
me. What do I need to change to use an encrypted password?
Brian
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: dev@umpa-us.com, pgsql-general@postgresql.org
Subject: Re: Database users Passwords
In-Reply-To: <002c01c6f1fa$652d3f60$0b01a8c0@LT003>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox