Re: Reassign permissions

Поиск
Список
Период
Сортировка
От Rene Romero Benavides
Тема Re: Reassign permissions
Дата
Msg-id CANaGW09XYaFv9yT8mhGjc=xXmZ0iSDH+8Nq9j1uMr1Xg4r4P+Q@mail.gmail.com
обсуждение исходный текст
Ответ на Reassign permissions  (Amreen Khan <amreenkhan@hotmail.com>)
Список pgsql-sql
How about defining it with the SECURITY DEFINER modifier?

2015-08-25 14:20 GMT-05:00 Amreen Khan <amreenkhan@hotmail.com>:
I had a function that a group owns, I'm part of this group. I wanted to change the permissions or give grant delete privileges to session_user. And another group of users was granted all privileges on the function in order to be able to run it. My group still wants to own the function but we want whoever runs the function outside of our group to be able to have delete privileges on a table that is created within the function. Does anyone have any suggestions?

Amreen Khan



--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/

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

Предыдущее
От: Amreen Khan
Дата:
Сообщение: Reassign permissions
Следующее
От: David Nelson
Дата:
Сообщение: Showing a cumlative total by month