By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,933 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,933 IT Pros & Developers. It's quick & easy.

Groups vs. Roles

P: n/a
While playing at a new/different configuration in my brand spanking new Pg
7.4 instance :-) I noticed in the documentation that GROUPs are not in the
SQL Standard. So I go a looking and notice that Oracle does have ROLEs
and that they are quite different in how they are used.
Looking at the TODO list I see there is an entry about adding some
GROUPy stuff so ROLEs can be implemented. How close will ROLEs be with
these (object ownership) features added? Not that I'm in hurry to have
ROLEs but they are SQL Standard so I need to plan for them to happen.
(Actually I'm more interested in TABLESPACEs. :-)
Best,
Rod
--
"Open Source Software - You usually get more than you pay for..."
"Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL"

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Roderick A. Anderson writes:
Looking at the TODO list I see there is an entry about adding some
GROUPy stuff so ROLEs can be implemented. How close will ROLEs be with
these (object ownership) features added? Not that I'm in hurry to have
ROLEs but they are SQL Standard so I need to plan for them to happen.


The main missing things are group ownership of objects and nested
membership. What has been proposed is to unify users and groups into one
concept called role. This could make these things fall into place rather
easily.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #2

P: n/a
On Fri, 5 Dec 2003, Peter Eisentraut wrote:
The main missing things are group ownership of objects and nested
membership. What has been proposed is to unify users and groups into one
concept called role. This could make these things fall into place rather
easily.


Thanks Peter.
Rod
--
"Open Source Software - You usually get more than you pay for..."
"Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL"

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.