[ADMIN] grant execute on many functions

2004-06-29 Thread Jean-Denis Giguere
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 prob

Re: [ADMIN] grant execute on many functions

2004-06-30 Thread Jean-Denis Giguere
Tom Lane wrote: Doug Quale <[EMAIL PROTECTED]> writes: test=# select oid::regprocedure from pg_proc order by oid::regprocedure; doesn't sort the way I would expect. Nope, it'd just be ordering by the numeric OID. If you added a cast procedure as we were just discussing, you could order by oid::r