Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 827CF9FA0B7 for ; Sun, 10 Dec 2006 00:17:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 27241-02 for ; Sun, 10 Dec 2006 00:17:35 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web90509.mail.mud.yahoo.com (web90509.mail.mud.yahoo.com [216.252.100.176]) by postgresql.org (Postfix) with SMTP id E29E89F9F08 for ; Sun, 10 Dec 2006 00:17:34 -0400 (AST) Received: (qmail 78760 invoked by uid 60001); 10 Dec 2006 04:17:34 -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=b9l+HOgQv5MjLPUZd6BqqurJvLUW48kj1CsWLZwZCkAvOH/SG2nc2HYO9fbaG3YtUbg0UVP48kgpqlQmNGUy8DoRToAi7pImviCOm8z0KntMrggb6iV4BKejAO8d0fw4cSYot9Sb1lhpJ1K5g7cKwhRpcNHWvQgONqW5UETWvO8=; X-YMail-OSG: ld0J8EsVM1nf1xYl.QKFRtqOvXPVz9C.C59rQZFpvrnafUma5kKm94D3h4ohCrC5Ku2PYuvyt5ejoH3PADVfv1Zp7XRE0DmizEwxVF6vzejA8ASHg8ygzw-- Received: from [70.19.76.226] by web90509.mail.mud.yahoo.com via HTTP; Sat, 09 Dec 2006 20:17:34 PST Date: Sat, 9 Dec 2006 20:17:34 -0800 (PST) From: Philippe Salama Subject: Re: Difference between ROLE and USER1 To: Philippe Salama , Tom Lane Cc: PostgreSQL Admin In-Reply-To: <391149.23973.qm@web90514.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-701931212-1165724254=:78097" Content-Transfer-Encoding: 8bit Message-ID: <235135.78097.qm@web90509.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.212 tagged_above=0 required=5 tests=AWL, BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_30_40, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200612/133 X-Sequence-Number: 23925 --0-701931212-1165724254=:78097 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I found the novice subscribe link http://archives.postgresql.org/pgsql-novice/ and subscribed as Karebac at my other email. Tomorrow morning, I will unsubscribe her, and subcribe and post only if I have a legitimate ADMIN question, which probably wont be for a long time. Thanks! Philippe Salama wrote: 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. --------------------------------- Everyone is raving about the all-new Yahoo! Mail beta. --0-701931212-1165724254=:78097 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I found the novice subscribe link
http://archives.postgresql.org/pgsql-novice/

and subscribed as Karebac at my other email.

Tomorrow morning, I will unsubscribe her, and subcribe and post only if I have a legitimate ADMIN question, which probably wont be for a long time. Thanks!

Philippe Salama <karebacnyc@yahoo.com> wrote:
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.


Everyone is raving about the all-new Yahoo! Mail beta. --0-701931212-1165724254=:78097--