grant problem - Mailing list pgsql-general

From Rajarshi Mukherjee
Subject grant problem
Date
Msg-id df10886f0503220357dda464f@mail.gmail.com
Whole thread Raw
Responses Re: grant problem  (Bruno Wolff III <bruno@wolff.to>)
Re: grant problem  (Richard Huxton <dev@archonet.com>)
List pgsql-general
 Hello all,

 i have a function that updates a table. I gave execute grant on it to
 a particular user but no grant on the table in question.

 when logging in as that user and executing the function, i get an error
 ERROR: permission denied for relation <table_name>

 How can i ensure that any update on this table is only done through
 that function, and that the function is oublicly executable?

 Please provide suggestions.

 Thanks & Regards,
Raj.

pgsql-general by date:

Previous
From: Sean Davis
Date:
Subject: Re: pl/perl problem
Next
From: Michael Fuhr
Date:
Subject: Re: PHP SQL