How to protect a db from an sa user fetching its schema
- From: "Magnus Österberg" <magnus.osterberg@xxxxxxxxxxx>
- Date: Wed, 15 Mar 2006 16:40:21 +0200
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
.
- Follow-Ups:
- Re: How to protect a db from an sa user fetching its schema
- From: Mark J. McGinty
- Re: How to protect a db from an sa user fetching its schema
- From: Uri Dimant
- Re: How to protect a db from an sa user fetching its schema
- Prev by Date: Re: Stopping access to database outside application
- Next by Date: Re: How to protect a db from an sa user fetching its schema
- Previous by thread: Re: Stopping access to database outside application
- Next by thread: Re: How to protect a db from an sa user fetching its schema
- Index(es):