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