Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id E281D9FA2CB for ; Sun, 10 Dec 2006 00:01:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 05998-02 for ; Sun, 10 Dec 2006 00:01:29 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web90514.mail.mud.yahoo.com (web90514.mail.mud.yahoo.com [216.252.100.181]) by postgresql.org (Postfix) with SMTP id 2DB729F9386 for ; Sun, 10 Dec 2006 00:01:29 -0400 (AST) Received: (qmail 24232 invoked by uid 60001); 10 Dec 2006 04:01:28 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=dAq+BZ6V7TAYCE9HFLrZntIXjRG+sIs5ZMSXRYOqccU0oG+UKMSFGXmOOCM6xG7oExdej5yy06fyqHKUnM4/iw9JgC60tMnhmsEPvdfHxHQmsShlVBgm00AZtPqSW5kHYTnXcxlwsY0/O50bCbw/M0UpWcyeZaxRMB8vwU0UtVM=; X-YMail-OSG: FxwKAJ4VM1nQzcMo0RLYRi9SHnmE6PNvj8aQ6ryUQtYhaTfSBqfRRfHve49X_UrZr1oPVqMX0H.heZp.78i6S90KukDlBkqz9eV2pki_xNueQWDnsdGzgsmkFyy5.xeApCVah9UDhu9dKvtvZ6r5OvuKPAs81yUfOF8- Received: from [70.19.76.226] by web90514.mail.mud.yahoo.com via HTTP; Sat, 09 Dec 2006 20:01:28 PST Date: Sat, 9 Dec 2006 20:01:28 -0800 (PST) From: Philippe Salama Subject: Re: Difference between ROLE and USER1 To: Tom Lane Cc: PostgreSQL Admin In-Reply-To: <27823.1165721415@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-402119451-1165723288=:23973" Content-Transfer-Encoding: 8bit Message-ID: <391149.23973.qm@web90514.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.058 tagged_above=0 required=5 tests=AWL, BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200612/131 X-Sequence-Number: 23923 --0-402119451-1165723288=:23973 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Oh sorry about posting in the wrong forum. You are perfectly right. How do I navigate to join the novice forum? I will bookmark the link for future reference. Thanks for the explanation. I will post all future questions in the novice forum, once I find out how to join. Tom Lane wrote: Philippe Salama writes: > Ok, I found something on ROLE, but I am still puzzled on how ROLE differs from USER Users are the same thing as roles, pretty much. A user is a role with the LOGIN attribute ... roles with the NOLOGIN attribute correspond to what we used to call groups. You can find more about that in the docs: http://www.postgresql.org/docs/8.1/interactive/user-manag.html BTW, not to be impolite, but day-zero questions belong on pgsql-novice not pgsql-admin. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly --------------------------------- Everyone is raving about the all-new Yahoo! Mail beta. --0-402119451-1165723288=:23973 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Oh sorry about posting in the wrong forum. You are perfectly right.  How do I navigate to join the novice forum?  I will bookmark the link for future reference.  Thanks for the explanation. I will post all future questions in the novice forum, once I find out how to join. 

Tom Lane <tgl@sss.pgh.pa.us> wrote:
Philippe Salama writes:
> Ok, I found something on ROLE, but I am still puzzled on how ROLE differs from USER

Users are the same thing as roles, pretty much. A user is a role with
the LOGIN attribute ... roles with the NOLOGIN attribute correspond to
what we used to call groups. You can find more about that in the docs:
http://www.postgresql.org/docs/8.1/interactive/user-manag.html

BTW, not to be impolite, but day-zero questions belong on pgsql-novice
not pgsql-admin.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly


Everyone is raving about the all-new Yahoo! Mail beta. --0-402119451-1165723288=:23973--