GRANT EXECUTE doesn't work?!

From: Gémes Géza <geza(at)kzsdabas(dot)sulinet(dot)hu>
To: pgsql-admin(at)postgresql(dot)org
Subject: GRANT EXECUTE doesn't work?!
Date: 2003-05-06 12:58:30
Message-ID: 3EB7B176.9020504@kzsdabas.sulinet.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi everybody!

First of all sorry for my english.
I have a function, and I'd like to give the right to execute it to a
group, so I ran

#GRANT EXECUTE ON function_name_here TO group_name_here;

and also tried

#GRANT EXECUTE ON function_name_here(parametertype, e.g char(10)) TO
group_name_here;

No one works for me.

I ran postgresql 7.3.2 on Mandrake-Linux default build and install, RPMS:

postgresql-test-7.3.2-5mdk
postgresql-server-7.3.2-5mdk
postgresql-pl-7.3.2-5mdk
postgresql-docs-7.3.2-5mdk
postgresql-python-7.3.2-5mdk
postgresql-jdbc-7.3.2-5mdk
postgresql-contrib-7.3.2-5mdk
postgresql-tcl-7.3.2-5mdk
postgresql-7.3.2-5mdk
postgresql-devel-7.3.2-5mdk

I would be gracefull for any answer.

Geza Gemes
an unhappy admin

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message A.Bhuvaneswaran 2003-05-06 13:44:11 Re: GRANT EXECUTE doesn't work?!
Previous Message Fabio C. Bon 2003-05-06 12:21:16 A query with performance problems.