pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Difference between ROLE and USER1
5+ messages / 3 participants
[nested] [flat]

* Difference between ROLE and USER1
@ 2006-12-09 22:50  Philippe Salama <karebacnyc@yahoo.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Philippe Salama @ 2006-12-09 22:50 UTC (permalink / raw)
  To: pgsql-admin

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.

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Difference between ROLE and USER1
@ 2006-12-10 03:30  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Philippe Salama <karebacnyc@yahoo.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Tom Lane @ 2006-12-10 03:30 UTC (permalink / raw)
  To: Philippe Salama <karebacnyc@yahoo.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Difference between ROLE and USER1
@ 2006-12-10 04:01  Philippe Salama <karebacnyc@yahoo.com>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 2 replies; 5+ messages in thread

From: Philippe Salama @ 2006-12-10 04:01 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: 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.

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Difference between ROLE and USER1
@ 2006-12-10 04:17  Philippe Salama <karebacnyc@yahoo.com>
  parent: Philippe Salama <karebacnyc@yahoo.com>
  1 sibling, 0 replies; 5+ messages in thread

From: Philippe Salama @ 2006-12-10 04:17 UTC (permalink / raw)
  To: Philippe Salama <karebacnyc@yahoo.com>; Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin

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.

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Difference between ROLE and USER1
@ 2006-12-10 04:20  Richard Broersma Jr <rabroersma@yahoo.com>
  parent: Philippe Salama <karebacnyc@yahoo.com>
  1 sibling, 0 replies; 5+ messages in thread

From: Richard Broersma Jr @ 2006-12-10 04:20 UTC (permalink / raw)
  To: Philippe Salama <karebacnyc@yahoo.com>; Tom Lane <tgl@sss.pgh.pa.us>; +Cc: 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.  

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.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2006-12-10 04:20 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-12-09 22:50 Difference between ROLE and USER1 Philippe Salama <karebacnyc@yahoo.com>
2006-12-10 03:30 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-12-10 04:01   ` Philippe Salama <karebacnyc@yahoo.com>
2006-12-10 04:17     ` Philippe Salama <karebacnyc@yahoo.com>
2006-12-10 04:20     ` Richard Broersma Jr <rabroersma@yahoo.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox