FirebirdSQL logo

-⁠TR[USTED]

Use Windows trusted authentication (Win_Sspi).

Note
Introduced in Firebird 3.0.

-⁠U[SERNAME]

Allows the username of the SYSDBA, administrator user, or database owner user to be specified.This need not be supplied if the ISC_USER environment variable exists and has a correct value for the username, or if you are logged on to the server as a privileged account.

Syntax
-U[SERNAME] username
Note

A privileged account is one of the following:

  • root

  • firebird

  • interbase

  • interbas (without the final 'e')

If you log in to the server with one of these accounts, you will automatically receive SYSDBA privileges.If you use a different account, you may be required to supply a username and password, and optionally a role, to run gstat.

-⁠P[ASSWORD]

Supplies the password for the username specified above.This need not be supplied if the ISC_PASSWORD environment variable exists and has the correct value, or if you are logged on to the server using a privileged account.

Syntax
-P[ASSWORD] password
Note

Providing a username and password is not necessary when only specifying [gstat-cmdline-header].

Since Firebird 3.0, providing a password is usually not necessary.In most cases, gstat commands other than -⁠h will use the embedded engine to access the database, removing the need for a password.

When the database file is in use by a SuperServer instance, or the gstat executable is not part of a Firebird installation, and has no access to the Firebird embedded engine, it will connect to the local Firebird server using XNET or TCP/IP, in which case username and password (or another form of authentication) are required.

-⁠FE[TCH_PASSWORD]

This switch causes the password to be read from a file as opposed to being specified on the command line.

Syntax
-FE[TCH_PASSWORD] { password_filename | stdin | /dev/tty }

The filename supplied must be readable by the user running gstat.If the filename is specified as stdin, then the user will be prompted for a password.On POSIX systems, the filename /dev/tty will also result in a prompt for the password.

Note
Introduced in Firebird 2.5.