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
.
InterBase XE implements 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
In older versions of InterBase, the security database was named
isc4.gdb
. Because files with a gdb
extension automatically get backed up whenever they are touched in some versions of Windows XP, using this extension degrades database performance. Therefore, InterBase recommends using a different extension for database names.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
|
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