Hello,

I have a set of accounts in my database and I am cloning that database. If one of the people who login to that database change their account, then when I make a clone and import their data - i don't get the accounts.

How do I do that?

apologies if this is a FAQ

thanks in advance,

sincerely,

J__

You'll want a mechanism to reset the accounts in the new file. Probably need a table of users and their privilege set, use that to re-create the accounts with a default password.

Ender,

thanks for the response. So, first I guess this means there is no way to import accounts from an existing file right?

so, each time I make changes / updates I can get the user name and put it into a table, but the passwords, obviously will not be accessible; so I will have to reset the users password each time?

Is that how this is handled typically?

It's just we're doing updates often. I guess the other approach is for the users to set their passwords once and for all and then I clone that and hope no one will change the password.

any other suggestions?

thanks,

J__

No, there is no way to import accounts and passwords into another file.

I do my updates live, so I haven't had to deal with this yet. Although, it occurs to me that if I add a module (in a new file,) I will need to create the accounts in the new module to match the accounts in the rest of the system.

I suppose one approach is to use an encryption algorithm to store the encrypted password in the User table. Then decrypt it when a file needs an account reset.

The other option is to have your system just prompt users for a new password whenever you add a new module, or move things into an updated copy.

Ender,

thanks.

Yeh. That's what I figured. The thing is our users logged in and then changed their passwords.

My pattern has been to import the data from the system, because my version (which is a clone of that one) has the new script changes. So, I have had one person say "my password was not what I set it to be yesterday"... so it got us thinking about whether there was another way to handle this.

I think we'll probably just have them reenter their password.... maybe.

thanks for the prompt response.

sincererly,

J__