|
From: bill l. <cbi...@gm...> - 2008-04-12 02:00:49
|
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, |