Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 58F7D9FB398 for ; Tue, 17 Oct 2006 11:42:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 95864-07 for ; Tue, 17 Oct 2006 11:42:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.umpa-us.com (mail.umpa-us.com [64.9.53.20]) by postgresql.org (Postfix) with ESMTP id 30A459FB21B for ; Tue, 17 Oct 2006 11:42:03 -0300 (ADT) Received: (qmail 18497 invoked by uid 511); 17 Oct 2006 10:42:02 -0400 Received: from 64.9.53.17 by umpa.us (envelope-from , uid 509) with qmail-scanner-1.25-st-qms (clamdscan: 0.83/792. spamassassin: 3.0.2. perlscan: 1.25-st-qms. Clear:RC:0(64.9.53.17):SA:0(-4.0/4.0):. Processed in 0.431691 secs); 17 Oct 2006 14:42:02 -0000 X-Antivirus-UMPA-Mail-From: dev@umpa-us.com via umpa.us X-Antivirus-UMPA: 1.25-st-qms (Clear:RC:0(64.9.53.17):SA:0(-4.0/4.0):. Processed in 0.431691 secs Process 18487) Received: from scutum.umpa-us.com (HELO LT003) (dev@umpa-us.com@64.9.53.17) by mail.umpa-us.com with SMTP; 17 Oct 2006 10:42:01 -0400 From: "DEV" To: Subject: Database users Passwords Date: Tue, 17 Oct 2006 10:41:56 -0400 Message-ID: <002c01c6f1fa$652d3f60$0b01a8c0@LT003> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_002D_01C6F1D8.DE1B9F60" X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 Thread-Index: Acbx+mTG2lQMmtbXTPmHf+HzI3Yh6A== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.299 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200610/822 X-Sequence-Number: 102348 This is a multi-part message in MIME format. ------=_NextPart_000_002D_01C6F1D8.DE1B9F60 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_002D_01C6F1D8.DE1B9F60 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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

 

 

------=_NextPart_000_002D_01C6F1D8.DE1B9F60--