Обсуждение: GRANT EXECUTE doesn't work?!

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

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

=# \df function_name_here -- ensure the datatype of the parameter

and try,
=# GRANT EXECUTE ON function_name_here(char(10)) TO GROUP group_name_here;

regards,
bhuvaneswaran

=?ISO-8859-2?Q?G=E9mes_G=E9za?= <geza@kzsdabas.sulinet.hu> writes:
> #GRANT EXECUTE ON function_name_here(parametertype, e.g char(10)) TO
> group_name_here;

According to the manual, the syntax is
    GRANT EXECUTE ON FUNCTION funcname(params) TO GROUP groupname;

            regards, tom lane

Gémes Géza <geza@kzsdabas.sulinet.hu> writes: 

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

According to the manual, the syntax isGRANT EXECUTE ON FUNCTION funcname(params) TO GROUP groupname;
		regards, tom lane


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command   (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) 

GRANT EXECUTE ON FUNCTION funcname(params) TO GROUP groupname;