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.
- Invoke the command as:
gsec -user sysdba -password masterkey
- Define the
ISC_PASSWORDenvironment variables for
SYSDBAbefore you invoke the command.
gsecwhen you are logged in as root on UNIX or Administrator on Windows.
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
- Running gsec Remotely
- Running gsec with Embedded Database User Authentication
- Using gsec Commands
- Using gsec from a Windows Command Prompt