Skip site navigation (1) Skip section navigation (2)

Function script generator lacks revoke from public for ACL {postgres=X/postgres} -functions

From: "Knut P(dot) Lehre" <knutpl(at)broadpark(dot)no>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Function script generator lacks revoke from public for ACL {postgres=X/postgres} -functions
Date: 2011-04-08 18:07:14
Message-ID: 734081943df65.4d9f6af2@broadpark.no (view raw or flat)
Thread:
Lists: pgadmin-hackers
<div style="font-family: 'Times New Roman'; font-size: 16px;"><span _moz_dirty="">It is dangerous when working with security definer functions that the pgAdmin3 script creator does 
not include a &quot;revoke from public&quot; for functions with e.g. ACL 
postgres=X/postgres (at least in version 1.10.1). If you use this script
 to copy a function definition, then you will get public execute granted
 to that function.<br _moz_dirty="" />pg_dump adds a revoke from public in this case. Is 
this missing revoke in pgAdmin3 intentional or was it forgotten?<br _moz_dirty="" /><br _moz_dirty="" />KP Lehre<br _moz_dirty="" /><br _moz_dirty="" /></span></div>


Attachment: unknown_filename
Description: text/html (659 bytes)

Responses

pgadmin-hackers by date

Next:From: Dave PageDate: 2011-04-08 18:28:01
Subject: Re: Rework on the dialogs UI
Previous:From: Guillaume LelargeDate: 2011-04-08 13:38:34
Subject: Re: Rework on the dialogs UI

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group