pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDifference 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