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/