Last post Jun 14, 2011 03:31 PM by vicky.rajsharma
Jun 12, 2011 08:19 AM|vicky.rajsharma|LINK
Can anyone know a way to stop procedure decryption.
I have used WITH ENCRYPTION keywords while creating a procedure in MSSQL but.
There are some software and methods through which they can decrypt it .
Can anyone find out a way to stop them from decrypting my store procedure.
Vicky Raj Sharma
Jun 13, 2011 05:37 AMfirstname.lastname@example.org|LINK
Vicky, those softwares will work only based on your login details. if you didnt share the SQL login authentication then no once can decrypt your sp. because
first they can access your DB so, they can access your SP list
so, dont worry
Jun 13, 2011 07:37 AM|vicky.rajsharma|LINK
Yes your right, But I am developing the site for a client. He has the database access. But i dont want him to view my stored procedure business logic.
So, if it possible for me to stop him from viewing the stored procedure. I would be very grateful to have a solution.
Jun 14, 2011 05:40 AMemail@example.com|LINK
Vicky thats good question.
While you deliver the database to your client you should tell them "if they directly enter on the database and changed anything then we are not responsible", because if they purposely did that then how can we give a support for that. this rule is follwed
by all the business people while delivering the application.
so, you can feel free inform this to your client.
Jun 14, 2011 03:31 PM|vicky.rajsharma|LINK
It might be the answer.