On 25/04/2010 13:24, Andre Lopes wrote:
> Hi,
>
> I have a database were the users only can do operations using views,
> they have not access to physical tables. But I have a function with a
> lock on a physical table. Can I allow this users to run a function that
> locks a physical table?
You can create a function with SECURITY DEFINER, allowing it to be run
with the privileges of the users who created it rather than the user who
is running it. See here:
http://www.postgresql.org/docs/8.4/static/sql-createfunction.html
Would this do what you need?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie