Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

Re: [ODBC] Proposal for new pgsqlODBC feature - hiding tables inaccessible to the current user

From: Hiroshi Inoue <inoue(at)tpf.co.jp>
Date: Wed Jun 20 2007 - 10:47:48 EDT


Sorry for the late reply.

Mark Cave-Ayland wrote:

> On Thu, 2007-06-07 at 17:13 +0100, Mark Cave-Ayland wrote:

>> 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.

Recently added boolean options are defined as some bits in Extra Opts. Is it OK to define the option as a bit in Extra Opts ?

>> 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.

Isn't it sufficient to chack SELECT privilege only ?

>> 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.

regards,
Hiroshi Inoue

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org Received on Wed Jun 20 10:49:34 2007

Do you need help?X

This archive was generated by hypermail 2.1.8 : Wed Jun 20 2007 - 10:50:01 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library