On Wed, Aug 12, 2009 at 8:00 AM, Gaurav K Srivastava<gaurav...@gmail.com> wrote: > > The following bug has been logged online: > > Bug reference: 4980 > Logged by: Gaurav K Srivastava > Email address: gaurav...@gmail.com > PostgreSQL version: 8.3 > Operating system: Windows xp > Description: Dblink issue > Details: > > I have created a user by command > > > 1: create user posuser with password ‘pos’; > 2: create database chserver with owner = abc; > 3: GRANT ALL PRIVILEGES ON database chserver TO posuser > > > Now I have a schema under it named 'pos' > > Now there is a table 'tickets' ie pos.tickets > > Now I want to make a trigger which link another database say it is chclient > using dblink while inserting any row in tickets table. > > then i got dblink function is undefined. > > after running contrib/dblink.sql > i got the error while using dblink > is > ERROR: permission denied for language c > > and when I run the command > > ALTER PROCEDURAL LANGUAGE C OWNER TO posuser; > > then also I got the same error. > > Please tell me how i make the dblink function available to posuser which is > non super user.
http://www.postgresql.org/docs/current/static/sql-grant.html I suspect you want some variant of "GRANT USAGE ON LANGUAGE ...". ...Robert -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
