Re: How to secure the DB on a customer SQL server
From: Bruce A. Carson (bcarson_at_asgoth.com)
Date: 07/17/03
- Previous message: Mark Broadbent: "Re: Protecting my database"
- In reply to: Reinier: "How to secure the DB on a customer SQL server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 17 Jul 2003 10:56:34 -0400
The question about securing data seems to come up a lot... As answered by
other posters there is no way
to secure your data if someone has the "sa" password. Stored procedures are
another matter - you can stop
people from viewing them by encrypting them: Just add "WITH ENCRYPTION" to
your create proc statement. This does not stop someone from completely
replacing the proc with another one, however.
Bruce
"Reinier" <R_Gugten@hotmail.com> wrote in message
news:0c3101c34ba9$256443b0$a401280a@phx.gbl...
> Hi there,
> I develop a software prog. that uses the SQL server. I
> want to give access rights to the SQL depending on how the
> uses loggs onto my software. I do not want anyone to be
> able to change data in my database or to view/edit my
> stored procedures.
> Can anyone help me out here?
>
> Thansk.
>
> Reinier.
- Previous message: Mark Broadbent: "Re: Protecting my database"
- In reply to: Reinier: "How to secure the DB on a customer SQL server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
