Re: Can I prevent customers from viewing schema?
From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 06/08/04
- Previous message: Kevin McDonnell [MSFT]: "RE: 'Probe' account needed in SQL 2000?"
- In reply to: Bob Altman: "Can I prevent customers from viewing schema?"
- Next in thread: Bob Altman: "Re: Can I prevent customers from viewing schema?"
- Reply: Bob Altman: "Re: Can I prevent customers from viewing schema?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 8 Jun 2004 15:49:14 -0400
Bob,
The schema definitions in a database are avialable to public, which means
that anyone can read them. Trying to subvert this would probably cause you
some real problems.
For the future: http://tinyurl.com/th9k "An Overview of SQL Server "Yukon"
for the Database Developer" makes the following interesting comment:
SQL Server "Yukon" ships with a new security model that separates users from
objects, provides fine-grain access and provides greater control of data
access. Additionally, all System tables are now implemented as Views,
providing greater control over database system objects.
Wait and see on that one, I guess.
Russell Fields
"Bob Altman" <rda@nospam.com> wrote in message
news:ekz#SlWTEHA.384@TK2MSFTNGP10.phx.gbl...
> Hi all,
>
> I'm struggling with the pros and cons of developing a new desktop app
using
> Jet or MSDE/SQL Server. If I use MSDE/SQL Server, my installer would need
> to be able to either install MSDE (if it's not installed already) or
locate
> an existing SQL Server in which to create my database.
>
> One thing that I would like to accomplish is a little protection of my
> intellectual property. Specifically, I'd like to prevent customers from
> looking at my database schema. Is this possible (or practical) in a
> production SQL Server environment? If so, what is involved?
>
> TIA!
>
> - Bob
>
>
- Previous message: Kevin McDonnell [MSFT]: "RE: 'Probe' account needed in SQL 2000?"
- In reply to: Bob Altman: "Can I prevent customers from viewing schema?"
- Next in thread: Bob Altman: "Re: Can I prevent customers from viewing schema?"
- Reply: Bob Altman: "Re: Can I prevent customers from viewing schema?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
