Solved

Protecting/Encrypting DataBase Objects

Posted on 1998-07-28
1
184 Views
Last Modified: 2012-05-04
My employer has asked me If I can encrypt the MS-SQL Views, Triggers and Stored Procedures in a clients database.  He mentioned that he has heard that MS-SQL can Encrypt database objects to stop other people coping them.  My Question is:   Is this possible?  if it is, how do I go about doing it? If it's not... how else can I secure a deployed DB?
0
Comment
Question by:KirkGray
1 Comment
 
LVL 7

Accepted Solution

by:
spiridonov earned 100 total points
Comment Utility
You just need to add WITH ENCRYPTION statement to your create statements, here is an extract fro help.

CREATE TRIGGER [owner.]trigger_name
ON [owner.]table_name
FOR {INSERT, UPDATE, DELETE}
[WITH ENCRYPTION]
AS sql_statements

CREATE VIEW [owner.]view_name
[(column_name [, column_name]...)]
[WITH ENCRYPTION]
AS select_statement [WITH CHECK OPTION]

CREATE PROCedure [owner.]procedure_name[;number]
      [(parameter1 [, parameter2]...[parameter255])]
[{FOR REPLICATION} | {WITH RECOMPILE}
      [{[WITH] | [,]} ENCRYPTION]]
AS sql_statements


NOTE: You will not be able to edit objects, that you created  with this option, so you have to store the code somewhere else.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now