The InterBase Security Database

Go Up to Database User Management

The InterBase server stores the names and passwords of its authorized users in a special security database that resides in the InterBase home directory. By default, it is named admin.ib.

Note:
For information on stronger password protection on InterBase databases. See Implementing Stronger Password Protection.

You can use another name for the security database if you wish. If you change this name, you must add an entry to the ibconfig file, setting ADMIN_DB to the new name.

ADMIN_DB newname.ib

Note:
You can use any file extension for database files, but InterBase recommends using .ib.

Every user of an InterBase server requires an entry in the InterBase security database. The gsec security utility lets you display, add, modify, or delete information in the security database. IBConsole provides a graphical interface for the same functionality. The following table describes the contents of the security database:

Column	Required	Description
User name	Yes	The name that the user supplies when logging in; maximum length is 31 bytes.
Password	Yes	The user’s password Case sensitive Only the first eight bytes are significant Maximum length: 32 bytes.
UID	No	An integer that specifies a user ID.
GID	No	An integer that specifies a group ID.
Full name	No	User’s real name (as opposed to login name)

See Also

• Security Model
• Implementing Stronger Password Protection
• Enabling Embedded User Authentication
• System Table Security
• SQL Privileges
• Groups of Users
• Other Security Measures
• User Administration with IBConsole
• User Administration With the InterBase API
• Using gsec to Manage Security
• Using gsec to Manage Database Alias
• gsec Error Messages

Advance To:

• Implementing Stronger Password Protection