Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Protecting/Encrypting DataBase Objects

Posted on 1998-07-28
1
Medium Priority
?
214 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:
Victor Spiridonov earned 400 total points
ID: 1089287
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

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

972 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