Re: create function (plpgsql): permission denied

Hi John,

when I make grant usage on language 'plpgsql' to my user, I get this
error:

ERROR: language "plpgsql" is not trusted

So, if I must trust my language, I won't need the grant usage of
language to my user, will I?

BTW, if my user is already the owner of schema, is really need the grant
all on schema to my user?

thanks,
Pedro Salazar.

On Mon, 2003-04-07 at 13:53, John Gunther wrote:
> From psql <databasename> -U<databaseowner>, issue:
> GRANT USAGE ON LANGUAGE plpgsql to <desireduser>;
> You may also need (to allow creation of the function)
> GRANT ALL ON SCHEMA <schemaname> TO <desireduser>;
>
> This will grant <desireduser> the usage of plpgsql even if it is untrusted.

--
PS
pedro-b-salazar(at)ptinovacao(dot)pt
PGP:0E129E31D803BC61