Re: Password Protect SQL SERVER
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/04/04
- Next message: PBS: "SQL 6.5 sa Password, how to change?"
- Previous message: HP: "Password Protect SQL SERVER"
- In reply to: HP: "Password Protect SQL SERVER"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: Password Protect SQL SERVER"
- Reply: anonymous_at_discussions.microsoft.com: "Re: Password Protect SQL SERVER"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 4 Feb 2004 10:23:28 -0500
If they own the server and are sa then you can't. sa can see or do
everything on the server.
-- Andrew J. Kelly SQL Server MVP "HP" <anonymous@discussions.microsoft.com> wrote in message news:a26901c3eb2c$e9d5d7e0$a601280a@phx.gbl... > We have a database that we distribute for our application > to customers. We add users to a user table to allow > access to the web application only. How can I protect the > database with a secret password that only we know and the > customer can only access the data and use the database > but cannot get to the database using EM or Query Analyser > unless he knwos the password. > > Help is appreciated. > > I am new to all this so if some one could please guide me > to the right direction. > > Thansk a lot.
- Next message: PBS: "SQL 6.5 sa Password, how to change?"
- Previous message: HP: "Password Protect SQL SERVER"
- In reply to: HP: "Password Protect SQL SERVER"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: Password Protect SQL SERVER"
- Reply: anonymous_at_discussions.microsoft.com: "Re: Password Protect SQL SERVER"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
