Function security?

Поиск
Список
Период
Сортировка
От stevew
Тема Function security?
Дата
Msg-id 172087791.961422.83@erica
обсуждение исходный текст
Ответы Re: [SQL] Function security?  (wieck@debis.com (Jan Wieck))
Список pgsql-sql
I wish to control access to some tables, so I do not want to grant
select to all users. Instead I would like to use some functions which
return the info.

So I have some tables owned by admin
I have a user who does not have select permission on the tables owned by
admin.
admin has created some functions which perform some selects on admin's
tables.
When user runs these functions, user gets permission denied.

Is there a way to let the user be admin when running the functions ????

You can do this with Oracle.

Any help appreciated

Regards,

Steve


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

Предыдущее
От: Howie
Дата:
Сообщение: optimizer woes ?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [SQL] optimizer woes ?