Menu

Unable to find where to set "Database Authentication"

0 votes

Hi,
I've used dbFront for a long time, and I've bought the pro version to be able to connect another DB using different users.
It seems that the documentation reported here (https://dbfront.com/connectionaccess) is not up-to-date, as those screens are unavailable on actual 1.4.0.0664 version. I can't find the place where I can enable the Database Authentication on the single connection, while the old connection seems to work smoothly. I've found something interesting in the ConnectionConfig of the old one, like

 <AuthType>DatabaseAuthentication</AuthType>
  <AuthDatabase>XXXXXXX</AuthDatabase>
  <AuthFunction>XXXXXXX</AuthFunction>
  <AdminUserList>
    <string>administrator</string>
  </AdminUserList>
  <UpdateUserList />
  <ReadOnlyUserList />
  <DeniedUserList />

that are not present in the ConnectionConfig of the new one. But even adding those data to the new connection, I'm unable to authenticate with a user present in the new DB (the SP is present in the new DB and AuthDatabase has been changed concordly).
Can you please help me please? Thanks!

in How To by (160 points)
You should not need to modify the config files directly.  To connect another database you would create a new connection in addition to your previous connection.   You could then set the new connection to use a different authentication.

1 Answer

0 votes

A possible source of confusion is that there are two levels / types of database authentication.

1) The first is the database authentication for the database connection. That is described in this documentation which explains how to add database connections. https://dbfront.com/databaseconnection

2) The second is the option to allow uses of an existing database connection to be authenticated by a stored procedure. That is described here: https://dbfront.com/databaseauthentication

I need to review the documentation to make the difference clearer.

by (65.3k points)
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
 |
Powered by Question2Answer
...