Re: Users/Groups -> Roles

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: pgsql-patches(at)postgresql(dot)org
Subject: Re: Users/Groups -> Roles
Date: 2005-06-27 06:40:36
Message-ID: 20050627064036.GV24207@ns.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Greetings,

(Sent this earlier, but afraid it may have gotten caught by the
too-big bug, so I'm reposting without the files attached, they can
all be found at: http://kenobi.snowman.net/~sfrost/pg_role/ ; there
are also gzip and uncompressed versions of the unified / context
diffs there for those who don't care for bzip2)

Attached please find files and patches associated with moving from the
User/Group system currently in place to Roles, as discussed
previously. The files are:

pg_authid.h
New system table, contains role information
To be placed in src/include/catalog, replacing pg_shadow.h

pg_auth_members.h
New system table, contains role/membership information
To be placed in src/include/catalog, replacing pg_group.h

role_2005062701.ctx.patch.bz2
Main patch, generated via cvs -z3 diff -c | bzip2
(gzip didn't quite get it under the 100K mark for the list)

role_milestones
List of milestones associated with my work on Roles support
'*' indicates that the milestone has been met/completed
'?' indicates uncertainty about if something should be done
No marker indicates an item which needs to be done
Note: Documentation needs to be updated

Again, my apologies for not getting this in sooner, it's been a little
hectic around here of late. I'm anxious to get feedback, comments,
corrections, etc.

Thanks,

Stephen

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2005-06-27 06:47:40 Re: contrib/rtree_gist into core system?
Previous Message Stephen Frost 2005-06-27 06:29:49 Users/Groups -> Roles

Browse pgsql-patches by date

  From Date Subject
Next Message Petr Jelínek 2005-06-27 08:10:05 Re: limiting connections per user/database
Previous Message Neil Conway 2005-06-27 06:35:14 Re: limiting connections per user/database