[Firebird-odbc-devel] ERROR[HY000][ODBC Firebird Driver][Firebird]no permission for read/select access to TABLE

[Marius P. <mar...@qb...>]

I developed a Web site using a Firebird database. The VB.NET program reads
from the database via ODBC connection.

When running from Visual Studio 2008, everything works fine. The program
(VB.NET) connects and queries the Firebird Database OK.

I then published the Web Site in the inetpub/wwwroot folder and browse it
with IIS. Now I get an exception:

ERROR[HY000][ODBC Firebird Driver][Firebird]no permission for read/select
access to TABLE CONTACT

(CONTACT is the name of my table)

The ODBC connection was created via Control Panel. It only specifies the
database path, no user name and password. The database registration in Flame
Robin is with "trusted user authentication" (no user name and password).

Why is it working from Visual Studio and not after publishing it?

How is it possible that Firebird ODBC driver does not have permission to
READ from a Firebird database?

Below is the response from Helen Borrie, who recommends I join this group.

Regards

 

Marius Popescu

QBuild Software

 C   O   R   P   O   R   A   T   I   O   N 


145 Renfrew Drive, Markham, ON L3R 9R6, CANADA
Phone +1 905 479 7811 EXT 64  

Email: mar...@qb...
<mailto:geo...@qb...> 

 

Helen Borrie wrote:

It happens because you have not passed a user name in the connection
parameters. 

When you use the fbclient that is in fbembed.dll, your client layer does not
need to pass username and password in the connection string in order to
connect to the database via the server that is embedded in fbembed.dll. This
works, because on Windows the embedded client-server connection does not
perform server-level authentication. However, if you do not supply a user
name, the client layer will pass just NONE or an empty string (depending on
Firebird version). 

However, SQL access privileges are based *in the database*. The situation
you have here is that the user name (CURRENT_USER is NONE or an empty
string) and the database has no privileges stored for NONE. 

All you need to do to fix this is configure the connection to pass the user
name of the user (in RDB$USER_PRIVILEGES in your database) that has the
required access privileges that your application requires. If you don't know
how to do that for the ODBC driver that you are using, please ask on the
forum for that driver. 

-- If it is the Firebird driver, the forum is
fir...@li...
<mailto:firebird-odbc-devel%40lists.sourceforge.net> . You can subscribe
from here: http://firebirdsql.org/index.php?op=lists#fb-odbc-devel

-- If it is a different driver, look in the vendor documentation for a
contact address for the forum for that driver

^ heLen ^