Re: DB getTables() and permissions, bug #5800
| From: | Leo Lutz | Date: | Thu, 27 Oct 2005 23:25:31 +0000 |
| Subject: | Re: DB getTables() and permissions, bug #5800 | ||
| References: | 1 2 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-40325@lists.php.net to get a copy of this message | ||
Gracefully, yes. Knowing what the actual cause of the 'throw' is not
currently possible. I'm think I'm going to add a bug report on that
aspect atleast because failure of permissions shouldn't result in a
DB_ERROR_NEED_MORE_DATA.
On 10/27/05, Daniel Convissor <danielc@analysisandsolutions.com> wrote:
> 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
>