From karebacnyc@yahoo.com Sat Dec 9 22:51:00 2006 Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 1948C9FA19D for ; Sat, 9 Dec 2006 18:51:00 -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 68776-09 for ; Sat, 9 Dec 2006 18:50:51 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web90508.mail.mud.yahoo.com (web90508.mail.mud.yahoo.com [216.252.100.175]) by postgresql.org (Postfix) with SMTP id 8C7FB9F9EED for ; Sat, 9 Dec 2006 18:50:55 -0400 (AST) Received: (qmail 97395 invoked by uid 60001); 9 Dec 2006 22:50:53 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=d7u77eN9o4Kw8AWUmbc1QonIVtoQnPAvHy0r+5n7QQBE0OKMxZaOgm1n+QEnL0o6J94SzUOViUdnj5APrltW/f5lnGqZNoE8zDwuwPywBq7qURDdcuOs+ycqH+4c9S1ZNCcTZEL/7XuilEnIG9LciTdAX+6T9aJIICekYI9iUEw=; X-YMail-OSG: PfYUfN4VM1ljzP_GEMQ52MttYEL3MKDejM8Oih77vVJRLkoKdAaHpGnFcVKCrvuI6Q-- Received: from [70.19.76.226] by web90508.mail.mud.yahoo.com via HTTP; Sat, 09 Dec 2006 14:50:53 PST Date: Sat, 9 Dec 2006 14:50:53 -0800 (PST) From: Philippe Salama Subject: Difference between ROLE and USER1 To: PostgreSQL Admin MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-792115856-1165704653=:83402" Content-Transfer-Encoding: 8bit Message-ID: <673423.83402.qm@web90508.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.237 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/124 X-Sequence-Number: 23916 --0-792115856-1165704653=:83402 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Ok, I found something on ROLE, but I am still puzzled on how ROLE differs from USER http://www.postgresql.org/docs/8.1/interactive/sql-createrole.html --------------------------------- Want to start your own business? Learn how on Yahoo! Small Business. --0-792115856-1165704653=:83402 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Ok, I found something on ROLE, but I am still puzzled on how ROLE differs from USER

http://www.postgresql.org/docs/8.1/interactive/sql-createrole.html


Want to start your own business? Learn how on Yahoo! Small Business. --0-792115856-1165704653=:83402-- From tgl@sss.pgh.pa.us Sun Dec 10 03:30:22 2006 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 3F3EC9FA182 for ; Sat, 9 Dec 2006 23:30:22 -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 93541-09 for ; Sat, 9 Dec 2006 23:30:16 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 90DAF9FA162 for ; Sat, 9 Dec 2006 23:30:17 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id kBA3UFdW027824; Sat, 9 Dec 2006 22:30:15 -0500 (EST) To: Philippe Salama cc: PostgreSQL Admin Subject: Re: Difference between ROLE and USER1 In-reply-to: <673423.83402.qm@web90508.mail.mud.yahoo.com> References: <673423.83402.qm@web90508.mail.mud.yahoo.com> Comments: In-reply-to Philippe Salama message dated "Sat, 09 Dec 2006 14:50:53 -0800" Date: Sat, 09 Dec 2006 22:30:15 -0500 Message-ID: <27823.1165721415@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/129 X-Sequence-Number: 23921 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 From karebacnyc@yahoo.com Sun Dec 10 04:01:34 2006 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-- From karebacnyc@yahoo.com Sun Dec 10 04:17:40 2006 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-- From rabroersma@yahoo.com Sun Dec 10 04:20:43 2006 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 2D7059FA1DA for ; Sun, 10 Dec 2006 00:20:43 -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 09734-06 for ; Sun, 10 Dec 2006 00:20:39 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web31803.mail.mud.yahoo.com (web31803.mail.mud.yahoo.com [68.142.207.66]) by postgresql.org (Postfix) with SMTP id 86BA59F9F08 for ; Sun, 10 Dec 2006 00:20:38 -0400 (AST) Received: (qmail 30324 invoked by uid 60001); 10 Dec 2006 04:20:37 -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=AUeFzUaS3qB820cqaHHr0UtGpC/u9MuqpPGEG8ngDuuBXg8EOWs5MnLupsf3Joc5AynEN4x+T6UQcWHi7mEgjqEmmSMV+hFHqXHvo2hwg07CI4hUBNIDx0vHag6QwRZsg5mpfZiJay3fKis2rCwPJo4K2xCnaeOMjl3Fj1Tv/4Q=; X-YMail-OSG: oWnnanoVM1mCy7T0j2zBggEJQt5zbZ9ZCDuq9vIC0OQvPYaXuW.Jz4Kt8kkI94E9XwDQt0U0FVmO2CcngG8eixY.BvyS3bfaTyn.sZDwMOBJPw7WiKCGh49x7Yd35GbbGdwRJ6haQP7X26g- Received: from [75.84.83.178] by web31803.mail.mud.yahoo.com via HTTP; Sat, 09 Dec 2006 20:20:37 PST Date: Sat, 9 Dec 2006 20:20:37 -0800 (PST) From: Richard Broersma Jr 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: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <549729.29768.qm@web31803.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.215 tagged_above=0 required=5 tests=AWL, BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: * X-Archive-Number: 200612/134 X-Sequence-Number: 23926 > 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. http://www.postgresql.org/community/lists/ You should spend some time to get familiar with the postgresql home page. There is alot of information that will do you well to read. http://www.postgresql.org/docs/techdocs this link is very useful if you are enterested in learning about SQL and postgresql. Regards, Richard Broersma Jr.