|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
November 21st, 2004, 01:05 PM
|
|||
|
|||
Security
I am starting to work on a new version of my software and am looking at Firebird as my database and Delphi as my programming language.
What I want to know is how does one distribute an applicate with Firebird and make sure your app does not conflict with another Firebird app? For example, if I create my product and use Firebird, the first thing I'd want to do is change the SYSDBA password so others (not using my GUI) can't see the data. This I think is easy to do, but what if my click already has another Firebird application that needs the default password for SYSDBA or worse yet, has changed it already? Any ideas? Thanks Paul
|
|
#2
November 22nd, 2004, 04:46 AM
|
|||
|
|||
|
Changing the SYSDBA Password
http://www.districtdna.com/Manual/GetStarted/ChangePW.htm
|
|
#3
November 22nd, 2004, 05:35 AM
|
||||
|
||||
|
The right solution is to use SYSDBA as the server management user and not as the application user, this is standard practice for every database.
Just use one specific user for your app and set it's privileges right, this will improve general security and prevent conflicts.
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Security |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
