Re: Controlling user table creation - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Controlling user table creation
Date
Msg-id Pine.LNX.4.30.0101282147070.831-100000@peter.localdomain
Whole thread Raw
In response to Controlling user table creation  ("Samuel Greenfeld" <gree3776@rowan.edu>)
List pgsql-admin
Samuel Greenfeld writes:

>    While I am no means an SQL wizard, one of the things I know
> postgres supports is the ability to create rules. At least under
> 7.0.2, it seems that rules can be applied to a system table, such as
> pg_tables.  Now, I don't know if SQL rules can do things a user
> normally could not do.  But given that I could create a rule on a
> pg_tables, one wonders if such a rule could be used to keep users from
> making tables.

It couldn't, because the CREATE TABLE code does not go through the rule
system.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


pgsql-admin by date:

Previous
From: "Samuel Greenfeld"
Date:
Subject: Controlling user table creation
Next
From: Lamar Owen
Date:
Subject: Re: RedHat RPM install errors - advice needed