I am using Python code
cur.callproc('function_a',[parameter1, parameter2]) for executing one function and this code is correct when I use a user having full DB permissions.
But when I use a private user, the psycopg2 returns an error in PostGIS functions
Error message: psycopg2.ProgrammingError: function st_setsrid(public.geometry, integer) does not exist LINE 9: ...geocodigo = num1 ORDER BY st_distance(st_transform(st_setsrid... ^ In SQL code: ... ORDER BY st_distance(st_transform(st_setsrid(a.geom,4674),4326),b.geom);
I tried many permissions for the private user but until now, just user with full permissions was accepted by Python code. What are the correct permissions for private user in PostgreSQL, or is there any other solution?