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

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

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

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

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

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