Re: Public Role for SQL 2000
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Fri, 18 May 2007 21:03:47 +0000 (UTC)
Tushar (tushar_vaja@xxxxxxxxxxx) writes:
Whenever user run my exe on his system, my app will create two DB on his
local system. 1 DB contain general info and second DB contain some very
confidenmt info. Now i do not want user(the person who has installed my
app) to access the second DB but he can access 1st DB if he wants. I do
not knwo how to implemet this thing. Please help.
Presumably the user who installed the application will have admin rights
on the machine, and you cannot hide anything from an administrator.
You can of course, store the data in the database encrypted, and then
your application could decrypt the data as needed. But since the
application would have to hide the encryption key somewhere, it's not
safe from a user who is dead set from accessing the data, but at least
it protects you from the stray wanderer.
In any case, you need to cover this situation in the license agreement,
and explicitly say that disclosing the data in the database is not
permitted.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Re: Public Role for SQL 2000
- From: Tushar
- Re: Public Role for SQL 2000
- From: Erland Sommarskog
- Re: Public Role for SQL 2000
- From: Tushar
- Re: Public Role for SQL 2000
- Prev by Date: Re: Help in SQL
- Next by Date: Re: Decryption within an application
- Previous by thread: Re: Public Role for SQL 2000
- Next by thread: Re: Public Role for SQL 2000
- Index(es):
Relevant Pages
|
|
