Hash: SHA1

             AUSCERT External Security Bulletin Redistribution

                    ESB-2007.0277 -- [Win][UNIX/Linux]
PostgreSQL privilege escalation vulnerability in SECURITY DEFINER functions
                               27 April 2007


        AusCERT Security Bulletin Summary

Product:              PostgreSQL 8.2.3 and prior
                      PostgreSQL 8.1.8 and prior
                      PostgreSQL 8.0.12 and prior
                      PostgreSQL 7.4.16 and prior
                      PostgreSQL 7.3.18 and prior
Publisher:            PostgreSQL
Operating System:     UNIX variants (UNIX, Linux, OSX)
Impact:               Increased Privileges
Access:               Existing Account
CVE Names:            CVE-2007-2138

Original Bulletin:    http://www.postgresql.org/about/news.791

Comment: Besides applying the update, further steps are needed to fix
         this vulnerability in existing deployments that make use of
         SECURITY DEFINER functions. Full details of this vulnerability
         and the steps needed are provided in the following document:

- --------------------------BEGIN INCLUDED TEXT--------------------

Subject:    [ANNOUNCE] PostgreSQL Releases: 8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19
From:       Bruce Momjian <bruce () momjian ! us>
Date:       2007-04-23 16:22:50
List:       postgresql-announce

The PostgreSQL Global Development Group has released updated versions
for PostgreSQL 8.2 and all back versions to patch a privilege escalation
exploit in SECURITY DEFINER functions.  All users of this feature are
urged to update to the latest minor version and follow instructions on
securing these functions as soon as possible.  This minor release also
contains other fixes, so all users should plan to deploy it.

Once you have updated, additional steps are required to secure your
database against the exploit.  Please read the release notes at
http://www.postgresql.org/docs/8.2/static/release.html and the TechDocs
article at http://www.postgresql.org/docs/techdocs.77 on how to
lock down your security definer functions, if you use them.

Downloads are in the usual places, http://www.postgresql.org/download.
As always, application of a minor release does not require a dump and
reload of the database.

The frequency of security fixes recently is a result of increased
scrutiny of the PostgreSQL code by government agencies and
security-conscious companies.  Rapid turnaround on security patches is
key to keeping PostgreSQL the most secure SQL database.  Your work and
vigilance in applying the latest security updates ensures that there
will never be a PostgreSQL "worm".

- -- 
  Bruce Momjian  <bruce@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

- --------------------------END INCLUDED TEXT--------------------

You have received this e-mail bulletin as a result of your organisation's
registration with AusCERT. The mailing list you are subscribed to is
maintained within your organisation, so if you do not wish to continue
receiving these bulletins you should contact your local IT manager. If
you do not know who that is, please send an email to auscert@auscert.org.au
and we will forward your request to the appropriate person.

NOTE: Third Party Rights
This security bulletin is provided as a service to AusCERT's members.  As
AusCERT did not write the document quoted above, AusCERT has had no control
over its content. The decision to follow or act on information or advice
contained in this security bulletin is the responsibility of each user or
organisation, and should be considered in accordance with your organisation's
site policies and procedures. AusCERT takes no responsibility for consequences
which may arise from following or acting on information or advice contained in
this security bulletin.

NOTE: This is only the original release of the security bulletin.  It may
not be updated when updates to the original are made.  If downloading at
a later date, it is recommended that the bulletin is retrieved directly
from the author's website to ensure that the information is still current.

Contact information for the authors of the original document is included
in the Security Bulletin above.  If you have any questions or need further
information, please contact them directly.

Previous advisories and external security bulletins can be retrieved from:


If you believe that your computer system has been compromised or attacked in 
any way, we encourage you to let us know by completing the secure National IT 
Incident Reporting Form at:


Australian Computer Emergency Response Team
The University of Queensland
Qld 4072

Internet Email: auscert@auscert.org.au
Facsimile:      (07) 3365 7031
Telephone:      (07) 3365 4417 (International: +61 7 3365 4417)
                AusCERT personnel answer during Queensland business hours
                which are GMT+10:00 (AEST).
                On call after hours for member emergencies only.

Comment: http://www.auscert.org.au/render.html?it=1967