INFO: How do I setup Acceler8DB/DataGate for Windows 7.0 to use Security 20

The information in this article applies to:

• Acceler8DB, Release 5.0 (version 7.112 or higher)
• Security
• Windows

SUMMARY:

Acceler8DB 5.0 and DataGate for Windows (formerly Acceler8DB) now has the ability to setup secure databases on Windows. The security provided is similar to OS/400 Security Level 20 which effectively grants all or nothing access to a database based on a valid userid/password. This new capability works with native Windows features to allow the administration of database security using the built-in system facilities. Once defined, every request to open a secured database will succeed only if the credentials provided by the client contain the requisite privileges as defined by the database's permissions settings. If the open request succeeds, then the requesting client is granted complete access to every file in the database. If the request fails, the client is denied access of any kind to the database and its contents.

MORE INFORMATION:

The DataGate server now has the ability to effect authorization control on its database similar to OS/400 Security Level 20. This is accomplished by utilizing the security features of Windows and NTFS as follows:

1. Create the database on an NTFS disk;
2. Set the desired permissions on the RootPath folder of the database (See Figure 2 and 3);
3. Add the DWORD Value "Options" to the database label in the Windows Registry and set it to 0x02 (See Figure 1).

Example:

Database label adb, located in "C:\Databases\adb"

Figure 1

Figure 2

Figure 3

Keywords: DataGate, Acceler8DB, Security, DG.NET, Secure, database, Windows