Thread: permissions on user-defined functions

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@qwest.net