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
--------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-support-dig...@yahoogroups.com
firebird-support-fullfeatu...@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
http://info.yahoo.com/legal/us/yahoo/utos/terms/
