Using gsec to Manage Security
Go Up to Database User Management
The InterBase command-line security utility is gsec
. This utility is used in conjunction with the InterBase security database (admin.ib
by default) to specify user names and passwords for an InterBase server. This tool duplicates the functionality of Server|User Security in IBConsole for Windows.
The security database resides in the InterBase install directory. To connect to a database on the server, users must specify a user name and password, which are verified against information stored in the security database. If a matching row is found, the connection succeeds.
Only the SYSDBA can run
gsec
. To do this, use one of the following methods:- Invoke the command as:
gsec -user sysdba -password masterkey
- Define the
ISC_USER
andISC_PASSWORD
environment variables forSYSDBA
before you invoke the command. - Run
gsec
when you are logged in as root on UNIX or Administrator on Windows.
To use gsec
interactively, type gsec
at the command prompt. The prompt changes to GSEC>
, indicating that you are in interactive mode. To quit an interactive session, type QUIT
.
Topics
- Running gsec Remotely
- Running gsec with Embedded Database User Authentication
- Using gsec Commands
- Using gsec from a Windows Command Prompt