MSDE Secury

Can I distribute a MSDE 1.0 database(SQL Server 7) so that the user cannot
see its contents even if the user has SQL server installed on his machine?
I use visual basic 6.0 and I need to distribute data that cannot be seen(nor
opened) by the user, except from the VB 6 application.
Rick
hi Rick,
Rick wrote:
> Can I distribute a MSDE 1.0 database(SQL Server 7) so that the user
> cannot see its contents even if the user has SQL server installed on
> his machine?
> I use visual basic 6.0 and I need to distribute data that cannot be
> seen(nor opened) by the user, except from the VB 6 application.
no, you can't... every SQL Server administrator (member of server's
sysadmins) will be able to access your database...
for further info please have a look at http://tinyurl.com/9rzrd
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||If it's sensitive text you want to protect from prying eyes, you could
introduce an encryption layer to your program - encrypt text before your save
it on the DB and decrypt it after selecting.
Jamie Clancy
Ulysses Systems, London
"Rick" wrote:

> Can I distribute a MSDE 1.0 database(SQL Server 7) so that the user cannot
> see its contents even if the user has SQL server installed on his machine?
> I use visual basic 6.0 and I need to distribute data that cannot be seen(nor
> opened) by the user, except from the VB 6 application.
>
> --
> Rick

MSDE newbie question: contents of default databases

Having installed MSDE and connected to it, it seems there are several
default databases already:
master
model
msdb
tempdb
Are these intended to be for any specific use?
How do I get a list of the tables that are in these databases?
Simon Elliott http://www.ctsn.co.uk
hi Simon,
"Simon Elliott" <Simon at ctsn.co.uk> ha scritto nel messaggio
news:ureI8NzQEHA.1624@.TK2MSFTNGP09.phx.gbl...
> Having installed MSDE and connected to it, it seems there are several
> default databases already:
> master
> model
> msdb
> tempdb
> Are these intended to be for any specific use?
> How do I get a list of the tables that are in these databases?
in order to limit distribution size, MSDE only ships with system database
you do not have to touch =;-D
these databases are relatated to MSDE itself and are not user database...
if you like some sample database, you can install the Northwind and Pubs
demo databases from
http://www.microsoft.com/downloads/d...DisplayLang=en
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply