Subject | Re: [ib-support] Firebird Deployment (Round 2 - Users) |
---|---|
Author | Marcus Monaghan |
Post date | 2003-01-09T11:10:11Z |
> Change your application install to ask for, if Firebird is alreadySounds good to me. Very sensible.
> installed, the SYSDBA password. With it, create a new user, thaqt will own
> your database.
> Im my modest opinion, you choose the rigth database, but a wrong approachto
> it. But you just need to change a few things to make it happen.Yes, you've engaged some very interesting thought patterns!!!
> Yes, you just failed in the installation approach. Instead of usingSYSDBA,
> thing about using a predefined user that will own your database. Oneyour
> friendly approach it's using some kind of prefix to your application to
> users, something like MYP_ARTUR, MYP_MARCUS, MYP_OWNER, etc.I'm like what I'm reading.
> You must check for other workstation related problems also. Imagine thatto
> your users will use Interbase also, even just the client. You don't want
> mess around other configurations.Is there a detailed document that goes into making a reliable installation?
I'm sure I've seen one somewhere.
> And yes, you still have security problems related to users can copy theThe SP and trigger code is going to be reasonably basic so they are welcome
> database to other computer and look at your sp and triggers code. For me
> it's not a problem. There are always alternatives. Adapt yourself, and
> Firebird'it.
to that. I've also come to the conclusion that if they want to mess about
with the database structure they can but the support will become null and
void and can only be re-instated for a costly fee. The data that is
sensitive will be encrypted.
Regards,
Marcus.