|
|
Posted by Cimode on 07/07/06 08:46
Erland Sommarskog wrote:
> mal hit (malehit@yahoo.com) writes:
> > I would like to know if it's possible to embed a SQL Server 2000/2005 DB
> > within a desktop application so that the end users cannot view the DB.
> > Also, this will prevent them from copying the database on to their other
> > SQL Servers.
>
> You can never hide anything from the system administrator. If users does
> not have admin rights on their boxes, you could hide the databases. But
> that would only work within an organisation.
Correct. To expand further. You need to design a database security
strategy based on SQL roles and capabilities. Not just on *hide from
users* vague concepts. I suggest you get some better understanding of
SQL security features before you design an efficient security strategy
plan...
> > Also, what are the options to load SQL Server 2005 on Win 98
>
> SQL 2005 does not run on Windows 98.
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> 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
Navigation:
[Reply to this message]
|