Hallo,
I have a database that I distribute with my application.
When I distribute updates for my application there are some updates for
the database that I apply with a script.
Even, I want to avoid that the user of my application can accidentally
deleting the data that I inserted.

I think to organize my database like this:
1) Create database with a user <> SYSDBA, like "MyAdminX";
2) Create user "MyAppAdministrator" with grant the user of my
application to:
a) create some other users for their farms and prevent duplicates;
b) create a backup and eventually restore the database;
3) When I distribute update for the database I apply them with my user
"MyAdminX" to prevent that the user make disasters on database;
4) I prevent, by my application, that the user use SYSDBA when it is
logging in my application, because SYSDBA is the default super-user of
Firebird and the user with it can do everything.
Is this right?

Then, I need to create the users "MyAdminX" and "MyAppAdministrator" in
the system of my user during installation of my application.
How can i create them? I need to use SYSDBA?

Thanks.
--

Luigi Siciliano
--------------------------