Thread: Difference between ROLE and USER1

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.

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

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.

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.

> 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.