grant problem - Mailing list pgsql-novice

From Rajarshi Mukherjee
Subject grant problem
Date
Msg-id df10886f050322223973e11f70@mail.gmail.com
Whole thread Raw
Responses Re: grant problem
List pgsql-novice
Hello All,
i have a problem here.

i am ony giving usage grant on a function in my schema  to another user.
Then how come he's been able to execute the function in the following way?

select ins.validate('nyname','mypassword');

But if i don't give usage grant and straight way give execute grant on
the function, the user gets an error:- permission denied for schema
ins.

i want to give the user execute grant on a particular funtion in my
schema and not all functions.

How can i do that?

Thanks & Regards,
Raj.

pgsql-novice by date:

Previous
From: "Cima"
Date:
Subject: Deleting data bases and tables?
Next
From: Michael Fuhr
Date:
Subject: Re: Deleting data bases and tables?