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.

Important:
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 and ISC_PASSWORD environment variables for SYSDBA 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

Advance To:

• Running gsec Remotely