Horton

Re: Compiling pl/pgsql functions

Josh Berkus <josh@agliodbs.com>

View thread View on postgr.es
From: Josh Berkus <josh@agliodbs.com>
To: Rod Taylor <rbt@rbt.ca>, Stephan Szabo <sszabo@megazone.bigpanda.com>
Cc: Rodrigo Sakai <rodrigo@2bfree.com.br>, pgsql-sql@postgresql.org
Date: 2004-02-22T19:34:47Z
Lists: pgsql-sql 
Rod,

> This is another one of those items where it would be nice if users
> didn't need access to read the system tables, but instead could rely on
> the information schema (with extensions) to see what they own or have
> access to use -- but nothing else.

Hmmm, that is a good question: can I, as a database user, query the source 
code for functions I don't have permissions on?    This seems like an easy 
adjustment to the system tables, if so.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco