| When
storing sensitive customer information in a Microsoft Access database, it
is extremely important that users of our applications understand how to
properly configure Active Server Pages applications and set proper
permissions to keep their databases secure. For example, setting improper
permissions on the server, the database, and the folder in which the
database resides can allow unscrupulous people to download your store's
database simply by using a browser.
Below are some recommendations for steps
to take to secure your store's Access database. Some of these require
administrator access to the server on which the ASP application resides.
If you do not have administrator rights on your website's server, then you
will need to ask your hosting service for assistance.
Disable directory browsing
1. Disable directory browsing on your web site. This will keep an
unscrupulous web surfer from easily learning the names of your database
and the directory in which your store's database resides.
Rename database folder and database
2. Rename the demo database that comes in
your download package as well as the folder in which the demo database
resides. Never use the default names. Note: Once you have renamed these
two items, you will have to make changes to the connection string in the
db.asp and global.asa files that came in your download package to reflect
the new path to your database.
Password-protect the database
3. Take possession of the database and
password protect it. Use 8 or more alpha-numeric (upper and lowercase)
characters. Even if an unscrupulous person should succeed in learning the
path to your database and downloading it, it will be password- protected.
To take possession of the database and
set a password, open Microsoft Access. When the dialog box pops up, click
the Cancel tab. Then click File>Open. Browse to the demo database.
Select it, but do not open it yet. On the Open button at the bottom right
of the dialog box, click the down arrow. Select Open Exclusive. The
database opens. Go to Tool on the menu bar. Select Security>Set
Database Password.
Encryption of credit card numbers
4. Encrypt credit card information stored
in the database. Included with all of our applications, except the Free
version which is not credit card-enabled, is an encryption utility for
encrypting credit card numbers stored in the database.
Deselect "Read" on database
folder
5. Once you have done all the above, have
uploaded the application to a subweb or virtual directory on your web
site, and set the proper ASP application permissions (see HOW
TO: Deploy an ASP Application to Another Server by Using Internet
Information Server for configuring and deploying an ASP application),
you must disable READ permissions on the server for your renamed database
folder. On a hosted server, this can be done by your hosting service or,
if you have administrator rights to the server, then follow the
instructions below.
- Open up the IIS Management Console by
clicking on "Start>Settings>Control Panel>Administrative
Tools>Internet Services Manager". Select your server and web
site containing the database folder from the cascading menus. Then right
click on the directory containing the database and select
"properties". A folder properties dialog box will pop up.
Deselect "Read" in the dialog box. If you do not have
permission to do this, have your hosting service do it.
- Alternatively, if you have Microsoft
FrontPage, open the web in FrontPage, right-click the database
directory, select Properties, then make sure that the “Allow files to
be browsed” box is unchecked.
Both of the above
will prevent unauthorized users who know or might guess the names of your
databases from using a browser to download your data to their local
computer.
Secure Socket Layer (SSL)
6. For increased protection against
unscrupulous web surfers, you should always pass sensitive data from the
checkout page through the Secured Socket Layer (SSL) protocol, which
requires the purchase of an SSL server certificate from Thawte or
VeriSign. For information about configuring our applications for SSL,
please feel free to email us. |