1

I need to hide the code of a sqlplus report. It's used by an aplication for generating reports. I've tried oracle's wrap function, but it only hides the PL/SQL source code but not the SQL*PLUS source code.

Would you please recommend me a method to do it?.

Thank you.

Improve this question
4
  • 3
    You realistically can't (barring something like encrypting it and having a program runs that decrypts it before it gets passed to SQL*Plus but that likely just moves the problem around). You can move any sensitive logic into stored procedures and wrap those, leaving your scripts to just do things like format reports. Even with wrapped code, though, if I control the database, I can unwrap the code if I want and, even without unwrapping, I can see pretty much any SQL statement I want. I've been able to point vendors at bugs in their wrapped code without needing to unwrap it. Commented Oct 23, 2019 at 16:01
  • 1
    yeah, you can't hide the SQL behind your reports, the DB will always know, and anyone with the right access to the database... Commented Oct 23, 2019 at 16:16
  • Does it have to be a SQL*Plus report, or can you use some other tool that would allow such obfuscation? Commented Oct 23, 2019 at 23:31
  • 1
    You can make wrap plsql procedure to run sqlplus inside from stored procedure Commented Oct 24, 2019 at 10:12
Related questions
1
Use DBMS_CRYPTO to encrypt data
0
JSP CODE dbms obfuscation toolkit.DESEncrypt DECRYPT Oracle
0
Encrypt / obfuscate TSQL code in stored procedures
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.