Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > General

Lost Password?

Thread Tools Display Modes
Old 09-24-2007, 04:12 AM
ZarrinPour ZarrinPour is offline
Senior Member
Join Date: Jul 2003
Posts: 232
Default How can i prevent my customer from viewing my Tables'Data?

Hi all
Followings are the steps that i do when i want to Deploy my Application on my Customer's computer

1) Installing Sql Server 2000 And MSDE with its tools
such as (Query Analizer,Enterprise manager....)
2) Installing Database
3) Creating Appropriate ODBC Connection
4) Installing Executable File of my App

I've been doing these steps all the time But Recently i noticed that some of my Naughty Customers
that have a little bit knowledge of Computer specially Sql, can easily access to my Database and its
Tables and do mischevoius tasks intentionaly or unintentionaly!!!

Ofcourse , i have this problem when the App deployed on a Single Computer But if there is a Server
Computer, there will be no problem because Server Computer has its own Password.

So my problem is how i can prevent my USERS from openning,viewing and even Editing my Data
in SqlServer Database with Enterprise manager ina Singlie computer not Server Computer
Could AnyOne Help me?

By the way As i said befor i'm using SqlServer2000, as you know every one who can access to EnterPrise Manager
Can open And See Table's Data Specially Administrator,now i want to know is there any way to
Lock, Encrypt Tables or something like that so nobody could open Tables Except Application!!!

Kind Regards.
Reply With Quote
Old 09-24-2007, 06:42 AM
johnjces johnjces is offline
Senior Member
Join Date: Oct 2001
Posts: 444
Default RE: How can i prevent my customer from viewing my Tables'Data?

One thought that comes to mind is to not allow NT Permissoin in your MS SQL databse. Allow ONLY MS SQL permissions and create a user or users with passwords in MS SQL.

These passwords could be hard coded in your code and in your install to make them a bit more difficult and of course you could encrypt decrypt them.

I would also use ADO rather than ODBC which would make such a bit easier... I think.

Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump

All times are GMT. The time now is 08:40 AM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.