Subject Re: [Firebird-general] Create new user
Author Martijn Tonies

> Firebird 1.5.
> I want to create a user of a database file.
> What SQL/script code can I use?

You cannot create users by SQL.

But let's get started from the beginning --

Users are "per database" and cannot be revoked access from a database.

Users are server wide, and all users can connect to all databases.

Inside a database, however, there can be granted access to objects.

Alternatively, there are "Roles", which can be seen as "database users".
is, each server user can have multiple roles, but should specify the role to
use when connecting to a database. Each role can then have access to certain
objects inside the database.

So by forcing your privileges to use database roles, you can then lock out
server users.

Do note that the server users SYSDBA and the database owner can always
access all objects.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
My thoughts:
Database development questions? Check the forum!