Re: How to protect a db from an sa user fetching its schema
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Wed, 15 Mar 2006 16:48:20 +0200
Hi
http://vyaskn.tripod.com/sql_server_security_best_practices.htm --------security
best practices
"Magnus Österberg" <magnus.osterberg@xxxxxxxxxxx> wrote in message
news:epiDl5DSGHA.4740@xxxxxxxxxxxxxxxxxxxxxxx
On a customer-owned SQL Server 2000, we've got our db placed, together
with other software vendors databases. How can we protect from that the
customer and\or the other companies from fetching the db schema of our db?
All parties are allowd to login with the sa account. Can we by any means
configure our db such that only we can access the schema, and the sa can
not?
Must all parties (companies) be given individual logins? Then, what about
the sa account? Using this, one is still entitled to the schema of all
databses, right?
Any web page were I can read about this?
Magnus
.
- References:
- How to protect a db from an sa user fetching its schema
- From: Magnus Österberg
- How to protect a db from an sa user fetching its schema
- Prev by Date: How to protect a db from an sa user fetching its schema
- Next by Date: Add user to R\O Database
- Previous by thread: How to protect a db from an sa user fetching its schema
- Next by thread: Re: How to protect a db from an sa user fetching its schema
- Index(es):
Relevant Pages
|
|
