Re: Limit sa capability

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 07/10/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Wed, 10 Jul 2002 11:30:10 -0600

No...you can't limit a sysadmins access.
Maybe you want to look at some encryption routine in the
front end. Or a third party encryption product. Some are
listed at:
http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=1&tabid=2
But I don't think it would really prevent updates.
If this is for intellectual property protection then
licensing agreement would be a good approach.

-Sue

On Wed, 10 Jul 2002 10:17:01 -0700, "Ray"
<rkano@adctech.com> wrote:

>Is there a way to password-protect select tables in an SQL
>2000 database so that they are not accessible to ANY user,
>including sa, without the proper password.
>
>I am developing an app and the system database contains
>several metadata tables that cannot be viewed or updated
>at end user installations via SQL Server. The only access
>is via the application.
>
>I am aware of an "Application Role" which limits access to
>applications supplying the proper password, but the
>sysadmin user is not restricted by this.
>
>