Search Postgresql Archives

Re: security permissions for functions

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

 



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


[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