Re: Difference between ROLE and USER1 - Mailing list pgsql-admin

From Philippe Salama
Subject Re: Difference between ROLE and USER1
Date
Msg-id 391149.23973.qm@web90514.mail.mud.yahoo.com
Whole thread Raw
In response to Re: Difference between ROLE and USER1  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Difference between ROLE and USER1
Re: Difference between ROLE and USER1
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: \c bpsimple rick
Next
From: Philippe Salama
Date:
Subject: Re: \c bpsimple rick