Skip site navigation (1) Skip section navigation (2)

Re: Proposal for new pgsqlODBC feature - hiding tablesinaccessible to the current user

From: Mark Cave-Ayland <mark(dot)cave-ayland(at)ilande(dot)co(dot)uk>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Proposal for new pgsqlODBC feature - hiding tablesinaccessible to the current user
Date: 2007-06-07 16:13:41
Message-ID: 1181232821.12462.10.camel@mca-desktop (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi everyone,

I've just completed the patch for only listing tables accessible by the
current user for psqlodbc as detailed in my email here:
http://archives.postgresql.org/pgsql-odbc/2007-05/msg00068.php. As
suggested in the original post, I have implemented a tick box called
"Only list user-accessible tables" on page 2 of the Datasource Advanced
Options dialog. When this box is ticked, only tables on which the user
has one of SELECT, INSERT, DELETE or UPDATE privileges will appear in
the table list for the given DSN.

I think that this would be a really useful feature to add to the
psqlodbc driver, and so I have attached a diff from CVS HEAD. As far as
I know, the only part I have missed is adding the tickbox and its
corresponding translation to the Japanese version of the dialog in
psqlodbc.rc. Please let me know if there is any more work I need to do
in order to get this applied.


Kind regards,

Mark.



Attachment: psqlodbc-listonlyusertables.patch
Description: text/x-patch (8.8 KB)

In response to

Responses

pgsql-odbc by date

Next:From: noreplyDate: 2007-06-08 19:50:28
Subject: [ psqlodbc-Bugs-1006030 ] Configuring using --disable-unicode is broken fro unix distribution
Previous:From: Rainer BauerDate: 2007-06-06 20:17:03
Subject: Re: [psqlODBC 08.02.0402] OpenSSL libraries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group