Re: Controlling user table creation

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Controlling user table creation
Дата
Msg-id Pine.LNX.4.30.0101282147070.831-100000@peter.localdomain
обсуждение исходный текст
Ответ на Controlling user table creation  ("Samuel Greenfeld" <gree3776@rowan.edu>)
Список 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 по дате отправления:

Предыдущее
От: "Samuel Greenfeld"
Дата:
Сообщение: Controlling user table creation
Следующее
От: Lamar Owen
Дата:
Сообщение: Re: RedHat RPM install errors - advice needed