Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
Hi friends,
 
How to hide the stored procedures in sql Server 2005.
Posted 6-Sep-12 18:47pm
Rockstar_5.7K

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

You can encrypt the text of the stored procedure, if that is what you mean.
CREATE PROCEDURE my_procedure
    WITH ENCRYPTION
    AS
    BEGIN
      SELECT *
      FROM my_table
    END
The encryption is not unbreakable, but at least it is a first line of defence.
From here[^]
 
Options for hiding SQL Server code[^]
  Permalink  
v2
Comments
VijayChauhan123 at 7-Sep-12 3:10am
   
thanks you very much for your response my friend,
i am going to hide the database, for this i followed the steps which are in the links you provided. But the databases are still visible by the user SA.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web04 | 2.8.140709.1 | Last Updated 7 Sep 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid