Re: Encryption

Rogers wrote:
Is there any way I can encrypt the stored procedure and that only I
can only decrypt it none of other user can do?

I can't use Ecryption reserve word becuase that can also be decrypted
through third party tool, is there any other way I can encrypt my
stored procedure with my own key or like that?

Thanks in advance.

There are some thrid-party solutions for object encryption. In general, you should be working/developing your stored procs (and other objects) using external files and version control software like PVCS or SourceSafe. It's not advisable to edit objects directly in the database. If you use one of the third-party solutions, that should help secure the objects, but I don't know if those tools support decryption or a more permanent type of encryption.

I just came across one of these tools today (I have no experience with the product or affiliation with them):
http://www.sql-shield.com/



--
David Gugick - SQL Server MVP
Quest Software

.

Relevant Pages

  • Re: WITH ENCRYPTION en masse
    ... most - also a deliberate act is required to decrypt - bit like someone ... Also, I want to encrypt Views, ... Triggers and UDF's - not just SPs. ... stored procedure I tested it on ...
    (microsoft.public.sqlserver.security)
  • RE: Programmatically decrypt stored procedure?
    ... know how to decrypt stored procedure, to keep the integrity of newsgroup, ... Secondly, from your descriptions, I understood that you may want to decrypt ... script(Use the Generate SQL Scripts dialog box) into the Execute SQL task. ... Create a database with encrypted objects and use this database for the ...
    (microsoft.public.sqlserver.dts)
  • Encryption
    ... Is there any way I can encrypt the stored procedure and that only I can only ... decrypt it none of other user can do? ... through third party tool, is there any other way I can encrypt my stored ...
    (microsoft.public.sqlserver.clients)
  • Re: Encryption
    ... can only decrypt it none of other user can do? ... stored procedure with my own key or like that? ... There are some thrid-party solutions for object encryption. ...
    (microsoft.public.sqlserver.clients)
  • how to decrypt the contents of ctext column in syscomments table
    ... i want to know how to decrypt the contents of ctext column in syscomments table through that can i get information about the parameters passed to stored procedure are mandatory or optional. ...
    (microsoft.public.sqlserver.server)