How do I add a user to the Local InterBase Security database

be...@tartarus.uwa.edu.au (Ashley Bennett)

Delphi Developer

Thu, 04 Feb 1999 03:00:00 GMT

How do I add a user to the Local InterBase Security database

I know that you can do this using the Server Manager that ships with Delphi, but
I'd like to be able to do this programatically - I don't like forcing the user
to leave SYSDBA and "masterkey" in their security database.

Also, what if the user already has Delphi/Paradox installed on their system and
has removed the SYSDBA or changed their password - there is then no way for our
Delphi apps to work on their systems...

Ash.
be...@cygnus.uwa.edu.au

Brad Ai

Delphi Developer

Sat, 06 Feb 1999 03:00:00 GMT

Re:How do I add a user to the Local InterBase Security database

Quote

be...@tartarus.uwa.edu.au (Ashley Bennett) wrote:
>I know that you can do this using the Server Manager that ships with
>Delphi, but I'd like to be able to do this programatically - I don't like
>forcing the user to leave SYSDBA and "masterkey" in their security
>database.

I was told be Borland Tech support that there is no programmatic way to add
users to Interbase.

Quote

>Also, what if the user already has Delphi/Paradox installed on their
>system and has removed the SYSDBA or changed their password - there is
>then no way for our Delphi apps to work on their systems...

It is possible to delete the administrative user -- there is no way to undo
this. The only solution is replacing the sc4.gdb security database.

--
Brad Aisa <ba...@tor.hookup.net> http://www.hookup.net/~baisa/

"The highest responsibility of philosophers is to serve as the
guardians and integrators of human knowledge." -- Ayn Rand

Other Threads

1. How to add users to an Interbase Database

2. Adding users to a Interbase database

3. Disturb Password Security in Local Interbase

4. Password Security dusturb in Local Interbase

5. Interbase Workgroup & Interbase Local databases

6. SQL databases and user security, restrictions

7. User security on Web IB database

8. Local Interbase slows down when adding records

9. Multi-User access to the LIBS ( Local Interbase Server )

10. Local DataBase table multi-user aware??