| From: | Rikard Pavelic <rikard(dot)pavelic(at)zg(dot)htnet(dot)hr> |
|---|---|
| To: | Shane Ambler <pgsql(at)Sheeky(dot)Biz> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: security permissions for functions |
| Date: | 2007-03-08 22:35:37 |
| Message-ID: | 45F08FB9.8030009@zg.htnet.hr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond O'Donnell | 2007-03-08 22:38:08 | Re: security permissions for functions |
| Previous Message | Rikard Pavelic | 2007-03-08 22:21:19 | Re: security permissions for functions |