Re: [libreoffice-users] Re: Base: connecting to a DB without requiring a password

I am trying to build a simple interface app for a user.  With 35 years
experience in software development, I can tell you:

1.  It is customary to password protect a database to prevent unauthorized
access.

2.  It is customary for applications that validate a user to have the
password embedded in the program so that each user doesn't have to know the
DB password.

That is what I am trying to do with Base.  (Also, I see no relationship
between your link and my question.)

Thanks.

Blake McBride


On Mon, Dec 21, 2015 at 4:18 PM, Andreas Säger <villeroy@t-online.de> wrote:

> Am 21.12.2015 um 22:47 schrieb Blake McBride:
> > What I want is to keep the password on the database but not require user
> > entry of it.  I have tried a bunch of stuff.  I added UserName and
> Password
> > to the odbc,ini file.  I also tried adding "Password=xyz" to Base's
> > database properties under ODBC options.  I also tried unchecking the
> > "Password required" option on Base DB setup.
> >
> > No matter what I do, it insists on getting a password.
>
> Of course it does. If you are the admininstrator of that database remove
> the password from your database account. If not, ask the responsible
> admin to do it for you.
>
> Anyhow:
> https://forum.openoffice.org/en/forum/viewtopic.php?f=21&t=77543 lets
> you store the "password required", the user name and the password
> _unencrypted_ within the database front-end. It is definitively a
> security breach.
> Install the oxt and call Tools>Macros>Run>FreeHSQLDB.FreeHSQLDB.Main.
> The macro shows a dialog to connect this document with an external
> HSQLDB but the upper part with registration and log-in works with all
> types of databases.
>
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted