How to protect store procedure
How i can protect store procedure from shared server. or i can make dll files of store procedure and used with asp.net
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
And incidentally, the only question that was not deleted (it was Force-Accepted) was identical to this question. See for yourself:
https://www.experts-exchange.com/questions/23854625/Protection-for-Sql-storeprocedure.html
https://www.experts-exchange.com/questions/23854625/Protection-for-Sql-storeprocedure.html
ASKER
I can not upload Store procedure from my end i have to deliver complied apllication along with Script for database which i generate from data publishing wizard so how i can encrypt store procedure?
As I mentioned earlier, add the WITH ENCRYPTION option while creating the stored procedure.
ASKER
If i create sp with encryption, can i create sql query with data publishing wizard?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
My problem is, in my web application i had near about 800 store procedures and i had to give to my client how i shall give sp in query form with encryption
>>My problem is, in my web application i had near about 800 store procedures and i had to give to my client how i shall give sp in query form with encryption<<
do you want to encrypt all 800 SPs? or set rights as per rrjegan17 to 800 SPs?
do you want to encrypt all 800 SPs? or set rights as per rrjegan17 to 800 SPs?
ASKER
Yes, I do with encrytion with every store procedure after final testing.Now how should i deliver encrypt sp to client so that he can upload from his end
You need to deliver the procedure code using WITH ENCRYPTION option to your client and can be installed out there.
To create the procedure you can't do that with Encrypted one.
But while Creating the Procedure, you can prevent from others viewing the code later, you can use WITH ENCRYPTION.
Hope this helps.
To create the procedure you can't do that with Encrypted one.
But while Creating the Procedure, you can prevent from others viewing the code later, you can use WITH ENCRYPTION.
Hope this helps.
For the record the author has asked 7 questions and has yet to close a single one.