[firebird-support] Grant and Revoke update (field)

2014-04-23 Thread Tomáš Beran
Hello, I have a problem with permissions. I test this problem on new database. I have two users (User1 and User2), one table (TEST_TABLE (PKID, NAME, AGE)). I set permission select and update(AGE) to both users. Now everything is all right, but when I revoke permission to USER2, then USER1 has

[firebird-support] Transliteration of identifiers, query buffers etc?

2014-04-23 Thread Kjell Rilbe
Hi, I've been wondering a bit about how Firebird handles transliteration of various parts of a query, in particular regarding (quoted) identifiers. My situation is that I have a database with default charset UTF8 and all char/varchar columns use this charset. I also always use UTF8 as

[firebird-support] Re: Cannot log into database

2014-04-23 Thread Virgo Pärna
On 22 Apr 2014 08:45:07 -0700, srotyli...@gmail.com srotyli...@gmail.com wrote: When I run the client trying to use the fdb on the WIN7 system I get an unknown user name or password error. If I point the ALIAS to the fdb on the old XP system I can run the client from the WIN7 system but it

Re: [firebird-support] Cannot log into database

2014-04-23 Thread srotyliano
Thanks for your comments. Lots to learn here and your comments are a great help. I was able to resolve the issue overnight. I first backed up the 1.5 fdb file with gbak, then installed FB 2.5 on the WIN7 system and used gbak to restore and convert the fdb file it to a 2.5 version. This works

[firebird-support] flamerobin access from client

2014-04-23 Thread byerly
I have a firebird (2.5) database being accessed by a custom application over a windows 7 network (32bit) The application works fine. The customer would also like full database access through flamerobin on a couple of the clients. Flamerobin works fine on the server system. I have set up a

Re: [firebird-support] flamerobin access from client

2014-04-23 Thread Jesus Garcia
I have set up a server connection on the client (server name - server, host - \\server, port- 3050) and registered the database (name - DB, path - \\server\, user - sysdba, password - masterkey). Try with the connection string: Server:c:\data\db.fdb _