Securing Data Tables from unauthorized viewing.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ISM - 22 Feb 2008 21:29 GMT

Is there any way to secure data tables in a SQL database from viewing by an
external program. We don't want the structure of our database be avilable
for viewing and possible reverse engineering of our application. Thanks.

Signature

Michael

Reply to this Message

Erland Sommarskog - 22 Feb 2008 23:02 GMT

> Is there any way to secure data tables in a SQL database from viewing by
> an external program. We don't want the structure of our database be
> avilable for viewing and possible reverse engineering of our
> application. Thanks.

There is no way to hide the metadata for a user with sysadmin access.
You can use WITH ENCRYPTION to obfusticate your stored procedures, but
anyone who wants to crack it, will.

The general recommendation is to use licenses to control your
intellectual property.

Signature

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Reply to this Message

ISM - 24 Feb 2008 16:59 GMT

Thank you.

Signature

Michael

> > Is there any way to secure data tables in a SQL database from viewing by
> > an external program. We don't want the structure of our database be
[quoted text clipped - 7 lines]
> The general recommendation is to use licenses to control your
> intellectual property.

Reply to this Message

Uri Dimant - 24 Feb 2008 09:19 GMT

ISM
If the login that application uses to coonect to is a member of sydadmin
you are out fu luck. Otherwise, take a look at VIEW DEFENITION command in
the BOL

> Is there any way to secure data tables in a SQL database from viewing by
> an
> external program. We don't want the structure of our database be avilable
> for viewing and possible reverse engineering of our application. Thanks.

Reply to this Message

ISM - 24 Feb 2008 17:00 GMT

Thank you.

Signature

Michael

> ISM
> If the login that application uses to coonect to is a member of sydadmin
[quoted text clipped - 5 lines]
> > external program. We don't want the structure of our database be avilable
> > for viewing and possible reverse engineering of our application. Thanks.

Reply to this Message