Hi,

Using Elevate DB Unicode 1.09 build 4 + Delphi 2007 for Win32

Guys, I must admit that I have got myself in a complete muddle
about encryption in EDB.  I'm sure it's actually easier than I think.

This was the scenario in DBISAM:
1. Existing table Sample.DAT is unencrypted.
2. Open DBSys.exe.
3. Choose menu option: Utilities > Restructure.
4. Check (tick) the "Encrypted" checkbox.
5. Enter new password "XYZ" in the enabled "Password" field.
6. Press Save to make the change permanent.
7. In the final application, issue this call to add password:
    Session.AddPassword('XYZ');

And the EDB scenario:
1. Existing table Sample.EDBTbl is unencrypted.
2. Open EDBMgr.exe.
3. Run SQL statement: ALTER TABLE "Sample" ENCRYPTED

4. But where and how do you set or change the actual password
  - on the user, session, database or server?
5. And what should the final application issue to set the password (if anything)?
6. Must the password be fixed before extracting or generating new tables?
7. Does the catalog file determine what the password currently is?

I'd be really grateful for some guidance.

Thanks,
Dan

EDB uses a single master set in the engine (TEDBEngine.EncryptionPassword
property).

See the "Configuring and Starting the Engine" for more details :
http://www.elevatesoft.com/manual?action=mantopic&id=edb2&product=r&version=2007&category=4&topic=6

Raul


"Dan Rootham" <roothamd@yahoo.co.uk> wrote in message
news:FB206782-2555-4497-922F-EF6D442B8885@news.elevatesoft.com...
> Hi,
>
> Using Elevate DB Unicode 1.09 build 4 + Delphi 2007 for Win32
>
> Guys, I must admit that I have got myself in a complete muddle
> about encryption in EDB.  I'm sure it's actually easier than I think.
>
> This was the scenario in DBISAM:
> 1. Existing table Sample.DAT is unencrypted.
> 2. Open DBSys.exe.
> 3. Choose menu option: Utilities > Restructure.
> 4. Check (tick) the "Encrypted" checkbox.
> 5. Enter new password "XYZ" in the enabled "Password" field.
> 6. Press Save to make the change permanent.
> 7. In the final application, issue this call to add password:
>     Session.AddPassword('XYZ');
>
> And the EDB scenario:
> 1. Existing table Sample.EDBTbl is unencrypted.
> 2. Open EDBMgr.exe.
> 3. Run SQL statement: ALTER TABLE "Sample" ENCRYPTED
>
> 4. But where and how do you set or change the actual password
>   - on the user, session, database or server?
> 5. And what should the final application issue to set the password (if
> anything)?
> 6. Must the password be fixed before extracting or generating new tables?
> 7. Does the catalog file determine what the password currently is?
>
> I'd be really grateful for some guidance.
>
> Thanks,
> Dan
>

Sorry, forgot to add you also have user based security now in EDB so use it
for table access control.

Use encryption to protect your tables while on disk (and for communication
if remote sessions) - hence the single password.

Raul


"Raul" <raul@raul.ca> wrote in message
news:726F7A50-3823-4470-BB9A-B63036C4217C@news.elevatesoft.com...
>
> EDB uses a single master set in the engine (TEDBEngine.EncryptionPassword
> property).
>
> See the "Configuring and Starting the Engine" for more details :
> http://www.elevatesoft.com/manual?action=mantopic&id=edb2&product=r&version=2007&category=4&topic=6
>
> Raul
>
>
> "Dan Rootham" <roothamd@yahoo.co.uk> wrote in message
> news:FB206782-2555-4497-922F-EF6D442B8885@news.elevatesoft.com...
>> Hi,
>>
>> Using Elevate DB Unicode 1.09 build 4 + Delphi 2007 for Win32
>>
>> Guys, I must admit that I have got myself in a complete muddle
>> about encryption in EDB.  I'm sure it's actually easier than I think.
>>
>> This was the scenario in DBISAM:
>> 1. Existing table Sample.DAT is unencrypted.
>> 2. Open DBSys.exe.
>> 3. Choose menu option: Utilities > Restructure.
>> 4. Check (tick) the "Encrypted" checkbox.
>> 5. Enter new password "XYZ" in the enabled "Password" field.
>> 6. Press Save to make the change permanent.
>> 7. In the final application, issue this call to add password:
>>     Session.AddPassword('XYZ');
>>
>> And the EDB scenario:
>> 1. Existing table Sample.EDBTbl is unencrypted.
>> 2. Open EDBMgr.exe.
>> 3. Run SQL statement: ALTER TABLE "Sample" ENCRYPTED
>>
>> 4. But where and how do you set or change the actual password
>>   - on the user, session, database or server?
>> 5. And what should the final application issue to set the password (if
>> anything)?
>> 6. Must the password be fixed before extracting or generating new tables?
>> 7. Does the catalog file determine what the password currently is?
>>
>> I'd be really grateful for some guidance.
>>
>> Thanks,
>> Dan
>>
>
>

Raul,

<< EDB uses a single master set in the engine (TEDBEngine.EncryptionPassword property).
 See the "Configuring and Starting the Engine" for more details :

http://www.elevatesoft.com/manual?action=mantopic&id=edb2&product=r&version=2007&category=4&topic=6

Sorry, forgot to add you also have user based security now in EDB so use it
for table access control.
Use encryption to protect your tables while on disk (and for communication
if remote sessions) - hence the single password. >>

Many thanks, that info will help me to sort this out.

Regards,
Dan