Subject RE: [firebird-support] Running modification scripts in FB1.5 security.fdb
Author Alan McDonald
> > > Hi!
> > >
> > > My application relies in modification of the security file (ISC4),
> > > using Ivan Prenosil scripts.
> > > This enables my users to modify their passwords.
> >
> > but below, you say manual changes is not an option
>
> I check the security file at the start of my application. If necessary I
> run the modification script (copies USERS table to USERS2, drops USERS
> and creates view USERS, etc.).
> automatically from my program. Users don't even have to know that
> something happened.
>
> >
> > What method(s) are yo using to change the users passwords?
> > You drop the whole table and re-install another which you have edited?
> > I doubt that this new feature will be re-introduced when it
> > was secuity driven in teh first place. But it appears that we
> > need to suggest anotehr way for you to edit your users
> > passwords rather than the way you are doing it.
> > What method of connection to the database do you have?
> > e.g. PHP has the ability to change user passwords, gee wiz..
> > gsec scripts can do it too. IBO has some good contributed
> > code for managing users
> >
> > Alan
>
> I don't edit users passwords. SYSDBA can manage users without problems,
> but normaly users are not allowed to change their own login passwords.
>
> Riho
>

Sorry - I'm still not with it - Why don't your uses change their own
passwords?
My apps provide for an admin of the app to add/delete users and reset
passwords. Each individual user can modify their own password only. Why is
there a need to drop tables?

Alan