grant execute on many functions

Поиск
Список
Период
Сортировка
Искать
От
Jean-Denis Giguere
Тема
grant execute on many functions
Дата
Msg-id
40E1E1A9.8080207@fastmail.fm
Список
Дерево обсуждения
grant execute on many functions Jean-Denis Giguere <jdenisgiguere@fastmail.fm>
Re: grant execute on many functions Joe Conway <mail@joeconway.com>
Re: grant execute on many functions Tom Lane <tgl@sss.pgh.pa.us>
Re: grant execute on many functions Joe Conway <mail@joeconway.com>
Re: grant execute on many functions Tom Lane <tgl@sss.pgh.pa.us>
Re: grant execute on many functions Joe Conway <mail@joeconway.com>
Re: grant execute on many functions Tom Lane <tgl@sss.pgh.pa.us>
Re: grant execute on many functions Tom Lane <tgl@sss.pgh.pa.us>
Re: grant execute on many functions Joe Conway <mail@joeconway.com>
Re: grant execute on many functions Doug Quale <quale1@charter.net>
Re: grant execute on many functions Tom Lane <tgl@sss.pgh.pa.us>
Re: grant execute on many functions Jean-Denis Giguere <jdenisgiguere@fastmail.fm>
Re: grant execute on many functions Doug Quale <quale1@charter.net>
Hi,

I have about 200 functions in a schema and I have to grant execute 
privilege on all these functions to a group.

I have found on the web an interesting function for grant access on table.
  http://www.lerctr.org/pgnotes/pgnotes.html 
(http://www.lerctr.org/pgnotes/grant-all.html)

But, the problem is more complex for functions because you have to give 
the arguments. You can find the list in the pg_proc table but they are 
store in a array by oid. So you can resolve the type with the table 
pg_type. After, you have to reproduce the correct syntax (with correct 
number of orgument, on one execute line...)

Is there a more simple approach to resolve this problem ?

Also if someone has a link to an advanced pl/pgsql documentation, I 
would really appreciate it because writing this function bypass my 
current knowledge of sql and the postgresql documentation on this topic 
don't give very complex examples.

Thank you for your attention,


--
Jean-Denis Giguère
Étudiant en géomatique appliquée à l'environnement
Université de Sherbrooke





В списке pgsql-admin по дате отправления
От: Gaetano Mendola
Дата:
От: Joe Conway
Дата:
FAQ