akp geek writes:
> Sorry for the confusion that I have caused
>- roles > role1 , role2
>- schemas > schema1, schema2
>- GRANT USAGE ON SCHEMA schema1 TO role2;
>- create function fnc_name(IN i_id numeric)
>- function is created using role2
> I ended up getting the error
> ER
Sorry for the confusion that I have caused
- roles > role1 , role2
- schemas > schema1, schema2
- GRANT USAGE ON SCHEMA schema1 TO role2;
- create function fnc_name(IN i_id numeric)
- function is created using role2
I ended up getting the error
ERROR: permission denied for sche
akp geek writes:
> I have 2 schemas , schema1 and schema 2.
> 1. GRANT USAGE ON SCHEMA schema1 TO schema2;
You seem to be confusing schemas and users --- they are not the same
thing at all. The above grants the right to lookup objects in schema1
to the user (a/k/a role) named schema2; who doesn
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,schema
