gsec
!!! = You usually have to be root to use gsec = !!!
To invoke gsec:
1) log in as root
2) cd /usr/bin
3) ./gsec
To create a new user:
GSEC> add [newusername] -pw [newuserpassword]
Example:
GSEC> add orca -pw raptor5
To delete a user:
GSEC> de(lete) username
Example:
GSEC> de orca
isql
!!! = In Debian, isql is found at /usr/bin/. In addition, note that it's called isql-fb NOT isql, due to some conflict in the package names. If you can't find it in usr/bin, try searching for it with whereis isql-fb = !!!
To invoke the isql command shell:
1) cd /usr/bin
2) ./isql-fb
Windows users (Firebird 2.1 on Windows 7):
So you've installed firebird, and checked that it's up and running.
As mentioned in the Quick Start guide, you should see it under 'Services'.
(Win 7: Start -> Control Panel -> System and Security -> Administrative Tools -> Services)
1) How the hell do you get into gsec thorough windows? Open a dos command window then cd to the directory and activate it?
I had minGW installed, and used the bourne shell that came with it.
Here's the script:
$ cd "C:/Program Files/Firebird/Firebird_2_1/bin"
$ pwd
$ gsec -user sysdba -pass masterkey -mo sysdba -pw raptor5
$ gsec -user sysdba -password raptor5
This will log you in as SYSDBA, and activate gsec so you can add a user or something.
2) Add user (in a possibly wasted effort to avoid fucking up with SYSDBA)
GSEC> add orca -pw raptor5
3) Exit
GSEC> quit
