Mick, When adding such a username runtime (e.g. through GSEC with ShellExecute), your application would still need to have access as sysdba, to add privileges for the new User to tables, procedures, etc.
Why don't you work with Roles? With roles you can set all priviliges to the Role, and let GSEC add the user name, password AND your defined Role. Regards, -----Oorspronkelijk bericht----- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Mick Arundell Verzonden: woensdag 20 augustus 2008 14:10 Aan: [email protected] Onderwerp: Creating a user from within Delphi > Date: Tue, 19 Aug 2008 21:09:07 +0100 > From: "Stevio" <[EMAIL PROTECTED]> > Subject: Creating a user from within Delphi > To: "Delphi DB" <[email protected]> > Message-ID: <[EMAIL PROTECTED]> > Content-Type: text/plain; format=flowed; charset="iso-8859-1"; > reply-type=original > > I have developed an application (Delphi 5 Pro) that connects to a Firebird > database using the standard sysdba username and password and at present this > is hardcoded in my application. I want to change this and have a specific > user set up for my application and database. > > However, when I deploy my application (for example if I make it available > for download from my web site), the user will need to install my application > and install Firebird. How can I then create the new specific Firebird user > that my application needs in order to access the database? > > I do not want to continue using sysdba because if they change the default > password for sysdba (which they should do really), then they will not be > able to use my application since the sysdba username and password are > hardcoded in my application. > > Thanks, > Stephen > Stephen, Your solution is quite easy. First make a form that prompts for username and password It could also prompt for database name, particularly if your users use aliases.conf (recommended) Remove your hard coded username, password and db name and replace the values with the values from your form. Then open your database. On one of these lists I posted a utility that encrypts these values (very simple encryption) and can store the encrypted username, password and db name in registry or an ini file. When my programs start they look for these details for this user and if available attempt to open the db with those credentials else they bring up the prompt form. In addition a dba can save the settings to a file on USB key and for each authorised user use the data on the key to set them up. Mick _______________________________________________ Delphi-DB mailing list [email protected] http://lists.elists.org/cgi-bin/mailman/listinfo/delphi-db Paul van Mil Senior Developer MAD-Systems Burg. van Suchtelenstr. 26 6641 XN Beuningen (Gld) The Netherlands Url: www.madsystems.nl Tel.: +31 (0)24-366 1501 Fax.: +31 (0)24-366 1502 Mob.: +31 (0)6 2251 4084 Email: [EMAIL PROTECTED] ************************************************************************* Disclaimer: MAD-Systems is de enige opdrachtnemer van alle werkzaamheden. Nederlands recht is van toepassing. De aansprakelijkheid van MAD-Systems is beperkt tot de uitkering die plaatsvindt onder de verzekering van MAD-Systems tegen beroepsaansprakelijkheid. Disclaimer: MAD-Systems is the exclusive contractual party with respect to all work and services undertaken. Dutch laws shall apply. The aggregate liability of MAD-Systems shall be limited to the proceeds available under MAD-Systems professional liability insurance. This e-mail message is intended exclusively for the addressee(s). If the e-mail was sent to you by mistake, would you please contact us immediately by e-mail through "[EMAIL PROTECTED]". In that case, we also request that you destroy the e-mail and that you neither use the contents nor disclose them in any manner to third parties, because the message may contain confidential information which is protected by professional secrecy. Any addressee should be aware that internet e-mail is subject to risks; MAD-Systems therefore denies any responsibility for damages resulting from the use of Internet e-mail. ************************************************************************* This email is checked on viruses through Norton Antivirus, updated 23-08-2008 _______________________________________________ Delphi-DB mailing list [email protected] http://lists.elists.org/cgi-bin/mailman/listinfo/delphi-db
