Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Posts
    57

    Unanswered: Stored Procedure security ideas??

    Does anyone know how you can distribute Stored Procedures that work with a third party application but keep the contents / code of those Stored Procedures from being viewed and edited by the end users who have purchased the application as well as own and operate the SQL Server??

    Thanks

  2. #2
    Join Date
    May 2002
    Location
    Sydney
    Posts
    45

    Re: Stored Procedure security ideas??

    Originally posted by parityah
    Does anyone know how you can distribute Stored Procedures that work with a third party application but keep the contents / code of those Stored Procedures from being viewed and edited by the end users who have purchased the application as well as own and operate the SQL Server??

    Thanks
    Can you not just encrpyt the stored procedure on the server?

  3. #3
    Join Date
    Oct 2003
    Posts
    57
    How would you encrypt it so that even the SQL Server administrator could not read it??

    Thanks,
    Parityah

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Try looking up "Encryption" in Books Online...

    ...though be aware that SQL Server's encryption algorythm has been broken and decryption routines are available on the web without much searching.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Jan 2004
    Posts
    10
    Look at option of creating extended stored procs (using Dlls)

    - amit

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •