Firebird Documentation IndexFirebird 3.0.6 Release Notes → Security
Firebird Home Firebird Home Prev: Parameters Removed or DeprecatedFirebird Documentation IndexUp: Firebird 3.0.6 Release NotesNext: Database Encryption

Chapter 7: Security

Table of Contents

Location of User Lists
Database Encryption
New Authentication Method in Firebird 3
"Over the wire" Connection Encryption
Mapping of Users to Objects
International Character Sets for User Accounts
SQL Features for Managing Access
Pseudo-Tables with List of Users
Restriction on DROP ROLE (v.3.0.1)

Security improvements in Firebird 3 include:

Location of User Lists

Alex Peshkov

CORE-685

Firebird now supports an unlimited number of security databases. Any database may act as a security database and can be a security database for itself.

Use databases.conf to configure a non-default security database. This example configures /mnt/storage/private.security.fdb as the security database for the first and second databases:

  first = /mnt/storage/first.fdb
  {
     SecurityDatabase = /mnt/storage/private.security.fdb
  }

  second = /mnt/storage/second.fdb
  {
     SecurityDatabase = /mnt/storage/private.security.fdb
  }
    

Here we use third database as its own security database:

  third = /mnt/storage/third.fdb
  {
     SecurityDatabase = third
  }
    

Note

The value of the SecurityDatabase parameter can be a database alias or the actual database path.

Creating an Alternative Security Database

To start using a separate, non-default security database, the first step is to create it, unless it already exists. An embedded isql connection is used:

  > isql -user sysdba
  SQL> create database '/mnt/storage/private.security.fdb';
      

Now connect to any database which will be served by the security database you are currently preparing, in order to create its SYSDBA user:

  SQL> connect first;
  SQL> create user sysdba password 'sysdba-in-private-security-password';
  SQL> commit;
  SQL> exit;
      
Prev: Parameters Removed or DeprecatedFirebird Documentation IndexUp: Firebird 3.0.6 Release NotesNext: Database Encryption
Firebird Documentation IndexFirebird 3.0.6 Release Notes → Security