More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
How secure are encrypted stored procedures, triggers and views?
Answerbr>
They are not really secure, that are only obfusticated. There are tools that you can use to get at the code.br>
br>
Explanationbr>
The code itself is just obfusticated. However, you cannot edit the code, the stored procedure or view would have to be dropped and re-created. By combing this fact with a DDL trigger that executes on object creation you can tell when it has been modified.
(Continued on next question...)
