Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 6 of 6 total |
Changing the catalog password |
Tue, May 20 2014 4:49 AM | Permanent Link |
Matthew Jones | I have a database, and I want to change the catalog encryption
password. How do I do this in EDB Manager please? In the immediate instance, I've actually resolved it another way, but it would be good to know if there is a simple command to do it somehow, or if it is complex. Matthew |
Tue, May 20 2014 7:51 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Matthew
Its on Tim's to do list to give us a simple command. I don't think its been done yet. How to do it in EDBManager was described in a post somewhere (I can't find it now) but I know it will have been before 19/1/2014 because I used its flow in building my own code. If you want to do it in code I can let you have mine. Essentially what I do is: 1. unencrypt any encrypted tables 2. go through the configuration database and extract the CreateSQL for: Modules, TextFilters, WordGenerators, Users, Roles, UserRoles, databases,Jobs, Stores (for Users get their passwords and replace <Password> with the real thing) 3. extract the permissions from configuration 4. close the TEDBSession component 5. delete the EDBConfig.EDBCfg file 6. alter the encryption password for the TEDBSession component and open 7. use the data extracted from the old configuration to create: Modules, TextFilters, WordGenerators, Users, Roles, UserRoles, databases,Jobs, Stores 8. use the data extracted from the old configuration to set the permissions 9. re-encrypt the tables that were deleted to start with IE its a non-trivial thing. Doing it in EDBManager was easier Roy Lambert |
Tue, May 20 2014 8:11 AM | Permanent Link |
Uli Becker | Roy,
> How to do it in EDBManager was described in a post somewhere (I can't find it now) but I know it will have been before 19/1/2014 because I used its flow in building my own code. Do you mean these posts? http://tinyurl.com/p7vsxu9 http://tinyurl.com/nw79eb2 Uli |
Tue, May 20 2014 8:12 AM | Permanent Link |
Matthew Jones | Roy,
Thank you for that. I shall tread warily so that I don't need to do this in future. At the moment I could probably use the database reverse engineering as I've not done a lot of roles etc. Thanks, Matthew |
Tue, May 20 2014 11:20 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Uli
The one who wrote them finding them is definitely cheating in my view I couldn't find it because I was spelling EDBManager properly Roy Lambert |
Tue, May 20 2014 11:23 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Matthew
>Thank you for that. I shall tread warily so that I don't need to do >this in future. At the moment I could probably use the database reverse >engineering as I've not done a lot of roles etc. Since my recruitment app has lots of personal data in it I decided that it would be better if whoever uses it could set their own password so login now consists of enter the encryption password, the user ID and the user password. That means I had to build the facility in. Even my development app and my live one have different encryption. Changing it it is now type in three words, click a button and fall asleep for a while. Roy |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |