Postgres Pro
Downloads
Home   >   mailing lists

Error 42501 permission denied for schema - Mailing list pgsql-general

From akp geek
Subject Error 42501 permission denied for schema
Date
Msg-id 2024a9fb1003260829j1e5d5695m7f5f5117cd83defb@mail.gmail.com
Whole thread Raw
Responses Re: Error 42501 permission denied for schema  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: John Gage
Date:
Subject: Re: Does anyone use in ram postgres database?
Next
From: Merlin Moncure
Date:
Subject: Re: Does anyone use in ram postgres database?