Re: Controlling user table creation

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/