Re: DB getTables() and permissions, bug #5800
| From: | Daniel Convissor | Date: | Thu, 27 Oct 2005 23:01:43 +0000 |
| Subject: | Re: DB getTables() and permissions, bug #5800 | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-40324@lists.php.net to get a copy of this message | ||
Hi Leo:
On Thu, Oct 27, 2005 at 02:54:14PM -0700, Leo Lutz wrote:
> DB/Dataproject/Generate halts when it tries to get tableinfo on a
> table that doesn't have usage permissions. This problem arises because
> in Postgres the getTables() function returns all tables whether the
> user has privileges for them or not.
>
> So my question, is this appropriate to fix in the pgsql driver or in
> the way Generate handles bad permissions.
Fixing it in DB would be awkward and might end up changing the behavior
for existing PostgreSQL users. Generate.php should gracefully catch the
permissions error.
--Dan
--
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
data intensive web and database programming
http://www.AnalysisAndSolutions.com/
4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409