Re: [Firebird-odbc-devel] ODBC driver with DBDezigner4

[bill l. <cbi...@gm...>]

Thomas Steinmaurer wrote:
> Hello,
> 
>> when using the latest ODBC driver (.0144) wih DBDezigner4 
>> (http://fabforce.net/dbdesigner4/), only one table RDB$ROLES is shown 
>> when reengineering a Firebird 2 database.
>>
>> Is this a known issue? Or, is anybody using the ODBC driver with 
>> DBDezigner4?
> 
> Not directly related to DBDezigner4, but I'm pretty sure it's the same 
> issue. An old post from Vladimir.
> 
> <message>
> 
> Hi, John!
> 
>  > I'm trying to iterate through the list of tables in my
>  > database using the SQLTables ODBC function call, but
>  > the only thing that gets returned is RDB$ROLES.
> 
>      Yes. This is right.
>      You should go SYSDBA and to give the privileges for USERS
> on viewing PUBLIC
> 
> --
> Best regards,
> Vladimir Tsvigun
> 
> </message>
> 
> 
> But I don't understand the above reply. Anybody?
> 
> 
> Thanks!
> 

I guess he meant that:

Yes. This is related to user's privilege right. You should login as SYSDBA and 
grant the users necessary privilege for viewing PUBLIC.

I think he implied that it should work if login Firebird as SYSDBA.

regards,