New article
Recently updated
Creating a VIEWER database user for ODBC connections
This article assumes the user already knows how to use the IBOConsole utility to run SQL scripts against a Firebird database.
On the Workbench server run IBOConsole (this is located in the \workbench\fbserver\bin folder). Enter the SYSDBA user password and click [Login].
Click on [Users] in the left-hand pane, then right-click in the right-hand pane and choose [Add User].
Enter a username of VIEWER with a password of viewer (lower case), confirm the password and then click [Apply]. Click [Close] on the User Information dialogue.
In IBOConsole, connect to the database you want to run the script against and then click on the [SQL] icon in the Toolbar. Once the Interactive SQL dialogue has opened select [Query | Load Script].
Navigate to the Desktop (or the location you saved the grant_11.sql file to) and then click the grant_11.sql file and then click the [Open] button.
The script should then be shown in the top pane of the "Interactive SQL window", click the execute button (Lightning symbol with a question mark), or [CTRL+E] on the keyboard.
The script should disappear without any errors shown, this means it has run successfully.
Repeat the above for all relevant databases and close out of IBOConsole. You should now be able to use the VIEWER user for any database queries, e.g. you wish to extract Workbench data from the database into Excel using the Firebird ODBC driver.