User authorization

From: Wayne Johnson <wdtj(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: User authorization
Date: 2005-06-28 14:32:36
Message-ID: 20050628143236.85571.qmail@web30205.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm using postgresql with Drupal. I have one small problem. I would
like to keep the Drupal tables available only to a small group of users
(apache, root and myself). I've set these user up in a group.

The problem is that every time I want to add a new Drupal module to the
database, I need to run the supplied script that creates the needed
objects. I then have to manually scan the script to find which objects
are created, and then grant access to them to my group.

Is there a way to do this automatically? Say, to make all new objects
accessible (or even owned) by a group? Something like the sticky bit in
a directory on UNIX.

Thanks for a great product.

---
Wayne Johnson, | There are two kinds of people: Those
3943 Penn Ave. N. | who say to God, "Thy will be done,"
Minneapolis, MN 55412-1908 | and those to whom God says, "All right,
(612) 522-7003 | then, have it your way." --C.S. Lewis

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2005-06-28 14:34:41 Re: Finding points within 50 miles
Previous Message Tom Lane 2005-06-28 14:31:46 Re: ERROR: "TZ"/"tz" not supported