Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Encryption advice |
Thu, Jun 19 2008 4:16 PM | Permanent Link |
Dan Rootham | 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 |
Thu, Jun 19 2008 7:30 PM | Permanent Link |
"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 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 > |
Thu, Jun 19 2008 7:47 PM | Permanent Link |
"Raul" | 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 >> > > |
Fri, Jun 20 2008 4:10 AM | Permanent Link |
Dan Rootham | 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 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |