Re: Security Issue..

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Security Issue..
Дата
Msg-id Pine.LNX.4.30.0204150014090.717-100000@peter.localdomain
обсуждение исходный текст
Ответ на Re: Security Issue..  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane writes:

> Peter Eisentraut <peter_e@gmx.net> writes:
> > For instance, if you create a view
> >     CREATE VIEW bar AS SELECT * FROM foo;
> > then the statement
> >     SELECT * FROM bar;
> > needs privileges to read "foo".
>
> This works just fine, thank you: the privileges are checked against the
> owner of the view.

OK, nevermind.  The case I was referring to was that the CREATE VIEW
statement succeeds and the privileges are checked when the view is
queried.  This is not in compliance with SQL, but it doesn't seem to
matter that much.

-- 
Peter Eisentraut   peter_e@gmx.net



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Rod Taylor"
Дата:
Сообщение: Re: [PATCHES] ANSI Compliant Inserts
Следующее
От: Curt Sampson
Дата:
Сообщение: Re: 7.3 schedule