Re: Users/Groups -> Roles - Mailing list pgsql-patches

From Stephen Frost
Subject Re: Users/Groups -> Roles
Date
Msg-id 20050627064036.GV24207@ns.snowman.net
Whole thread Raw
In response to Users/Groups -> Roles  (Stephen Frost <sfrost@snowman.net>)
List 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

pgsql-patches by date:

Previous
From: Neil Conway
Date:
Subject: Re: limiting connections per user/database
Next
From: Petr Jelínek
Date:
Subject: Re: limiting connections per user/database