permissions on user-defined functions

From: "Kevin T(dot) Manley \(home\)" <kmanley(at)qwest(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: permissions on user-defined functions
Date: 2001-01-13 02:51:06
Message-ID: 00e001c07d0b$ad3b49b0$5125e03f@networksheet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am new to PostgreSQL and have a (possibly silly) question.

I've created a table (table1) and database user (dbuser).
dbuser has only SELECT permission on table1.
Next I created a function insert_table1 that inserts a new row into table1.

I want to give dbuser the ability to invoke the insert_table1 function
without granting dbuser INSERT permission on table1.

Does PostgreSQL make this possible? Can someone kindly point out how to do
it?

Thanks!

Kevin T. Manley
kmanley(at)qwest(dot)net

Browse pgsql-general by date

  From Date Subject
Next Message Dave Cramer 2001-01-13 05:11:34 RE: xml middleware
Previous Message Soma Interesting 2001-01-13 00:16:12 Error reporting