|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 28th, 2005, 11:17 PM
|
||||
|
||||
|
How to change SYSDBA password automatically on installation?
I have a windows application using Firebird 1.5 and I need to automate the install procedure more.
How can I automatically set the SYSDBA password to what I need after installing Firebird? I also need to create 2 users on the srever and grant them read/write/execute premission ot all tables and procedures in my database file. What is the best way to automate this as part of the end user installation?
__________________
Beware of a programmer with a screwdriver!
|
|
#2
July 29th, 2005, 03:02 AM
|
||||
|
||||
|
Have your install script run the appropriate commands, or a batch file containing those commands.
__________________
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)
|
|
#3
July 30th, 2005, 04:57 AM
|
||||
|
||||
|
Also make sure you start the firebird service and the database is properly attached (aliased) before executing the commands.
__________________
If i've been helpful, please add to my reputation. My unfinished site: http://www.dever.ro
|
|
#4
July 31st, 2005, 07:06 PM
|
||||
|
||||
Thankyou for your suggestions.
I did not realise that GSEC could be used directly from the command line, I thought it was only an interactive utility. So for the benefit of anyone else who may be trying to solve this problem, use a command like this (with the passwords you need in the correct places): Code:
gsec -user sysdba -password origpaswd -modify sysdba -pw newpaswd
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > How to change SYSDBA password automatically on installation? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
