permissions on user-defined functions - Mailing list pgsql-general

From Kevin T. Manley \(home\)
Subject permissions on user-defined functions
Date
Msg-id 00e001c07d0b$ad3b49b0$5125e03f@networksheet.com
Whole thread Raw
List 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@qwest.net



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Copying an index from one copy of a database to another
Next
From: Patricia_Leong@tecsg.com.sg
Date:
Subject: SQL command for value comparison