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

From Kevin T. Manley \(Home\)
Subject permissions on user-defined functions
Date
Msg-id 941s73$bim$1@news.tht.net
Whole thread Raw
List pgsql-general
I am new to PostgreSQL...

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: "riccardo"
Date:
Subject: View table relationship
Next
From: "news.postgresql.org"
Date:
Subject: PostgresqlODBC