Search Postgresql Archives

Error 42501 permission denied for schema

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux