Academy & Industry Research Collaboration Center
In this paper, the authors are presenting a new way to disable DDL statements on some specific PL/SQL procedures to a DBA user in the Oracle database. Now-a-days DBA users have access to a lot of data and source code even if they do not have legal permissions to see or modify them. With this method they can disable the ability to execute DDL and DML statements on some specific PL/SQL procedures from every Oracle database user even if it has a DBA role. Oracle gives to developer the possibility to wrap the PL/SQL procedures, functions and packages, but those wrapped scripts can be unwrapped by using third party tools.