Restricting Database Login to a user
-
Hi, I'm a freelance developer, I have a database application i developed for a client. I have deployed the database on my client server. My client uses the builtin\administrator to login into the database server. My Question is I will like to protect my database from the builtin\administrator from accessing it, because i don't want them to access it from the backend. am a novice to sql server security. Note: its on Sql Server 2000. How do i protect my Database?
-
Hi, I'm a freelance developer, I have a database application i developed for a client. I have deployed the database on my client server. My client uses the builtin\administrator to login into the database server. My Question is I will like to protect my database from the builtin\administrator from accessing it, because i don't want them to access it from the backend. am a novice to sql server security. Note: its on Sql Server 2000. How do i protect my Database?
saltcode wrote:
client uses the builtin\administrator
Start by changing that (and its password). Give the client his own username, then apply whatever security you choose. Ideally you'd be using integrated security.
-
saltcode wrote:
client uses the builtin\administrator
Start by changing that (and its password). Give the client his own username, then apply whatever security you choose. Ideally you'd be using integrated security.