Error 42501 permission denied for schema

From: akp geek <akpgeek(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Error 42501 permission denied for schema
Date: 2010-03-26 15:29:47
Message-ID: 2024a9fb1003260829j1e5d5695m7f5f5117cd83defb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear all

I have 2 schemas , schema1 and schema 2.

1. GRANT USAGE ON SCHEMA schema1 TO schema2;

I am trying to create a function in shema2, In that function I need to
access some tables from schema1.
p
I am getting the following error when I compile the function

Search path set to schema2,schema1,public

Can you please help? Appreciate your time

Regards

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2010-03-26 15:40:55 Re: Does anyone use in ram postgres database?
Previous Message John Gage 2010-03-26 15:12:41 Re: Does anyone use in ram postgres database?