Postgres Pro
Downloads
Home   >   mailing lists

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

From Knut P. Lehre
Subject Function script generator lacks revoke from public for ACL {postgres=X/postgres} -functions
Date
Msg-id 734081943df65.4d9f6af2@broadpark.no
Whole thread Raw
Responses Re: Function script generator lacks revoke from public for ACL {postgres=X/postgres} -functions  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgadmin-hackers
Tree view 
<div style="font-family: 'Times New Roman'; font-size: 16px;"><span  _moz_dirty="">It is dangerous when working with
securitydefiner functions that the pgAdmin3 script creator does not include a "revoke from public" 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
youwill 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>

pgadmin-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: Rework on the dialogs UI
Next
From: Guillaume Lelarge
Date:
Subject: Re: Function script generator lacks revoke from public for ACL {postgres=X/postgres} -functions