Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
satish.gorijala
Posting Yak Master
182 Posts |
 Posted - 2010-02-02 : 00:08:48
|
| Hello,The application was developed in .NET and SQL 2005. Originally, we'd thought that it'd be a web-based application (i.e. the SQL database will be hosted by us and users can connect to it). But some clients want the database to be hosted on their computer itself. Of course the application needs the database to run, however, by putting the database on the client's machine we will lose control of our data.I cannot find an easy way that SQL provides to allow only the application to access the data, but not humans. Nothing is altered in the database--we are simply reading data from the SQL table, so should we explore other things (indexed flat files?) to make this into a software product without losing control over the data? The Database size is around 30GB.developer :) |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2010-02-02 : 01:29:49
|
| If you have proper access control mechanism in place (like creating a dedicated application user account to access database or using dedicated NT account for db access), you don't have to worry about database being accessible to humans.Harsh Athalyehttp://www.letsgeek.net/ |
 |
|
|
satish.gorijala
Posting Yak Master
182 Posts |
Posted - 2010-02-02 : 02:32:26
|
ya we had created only one user. By using that user credentails only any one can login to application. But when i place the database in client machine. he had a chance to access my DB(bcz he is an administrator to that system). So i want to avoid any of them inlcuding administrator not to access my database in their machine.quote:
Originally posted by harsh_athalye
If you have proper access control mechanism in place (like creating a dedicated application user account to access database or using dedicated NT account for db access), you don't have to worry about database being accessible to humans.Harsh Athalyehttp://www.letsgeek.net/
developer :) |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
|
|
|
|
|
Hiding the Database