Re: security permissions for functions - Mailing list pgsql-general

From Rikard Pavelic
Subject Re: security permissions for functions
Date
Msg-id 45F08FB9.8030009@zg.htnet.hr
Whole thread Raw
In response to Re: security permissions for functions  (Shane Ambler <pgsql@Sheeky.Biz>)
List pgsql-general
Shane Ambler wrote:
>
> You can but the default is to allow the execution of all functions.
>
> You need to revoke the existing permission of executing all functions
> before you can allow only a single function to be run.
>
> If you want a specific function to be accessed only by selected roles
> then you revoke public access when you create it and allow access to
> the one or more roles you want to allow access.
>
>

Oh, I see

Public access was being allowed by default when I created functions.

Oh my ;(
I'll go and hide somewhere now

Thanks,
Rikard

pgsql-general by date:

Previous
From: Rikard Pavelic
Date:
Subject: Re: security permissions for functions
Next
From: Raymond O'Donnell
Date:
Subject: Re: security permissions for functions