From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Samuel Greenfeld <gree3776(at)rowan(dot)edu> |
Cc: | "<" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Controlling user table creation |
Date: | 2001-01-28 20:48:14 |
Message-ID: | Pine.LNX.4.30.0101282147070.831-100000@peter.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)gmx(dot)net http://yi.org/peter-e/
From | Date | Subject | |
---|---|---|---|
Next Message | Lamar Owen | 2001-01-28 20:55:38 | Re: RedHat RPM install errors - advice needed |
Previous Message | Bogdan Paduraru | 2001-01-28 20:41:20 | Tuple problem |