grant problem

From: Rajarshi Mukherjee <mukherjee(dot)rajarshi(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: grant problem
Date: 2005-03-23 06:39:33
Message-ID: df10886f050322223973e11f70@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Cima 2005-03-23 06:40:22 pgsql.so
Previous Message Michael Fuhr 2005-03-23 06:37:21 Re: Deleting data bases and tables?