Auditing an Oracle database for security issues is very important. PeteFinnigan.com provides all of the information and tools that you will need Click here for details of PeteFinnigan.com Limited's detailed Oracle database security audit service Click here for details of PeteFinnigan.com Limited's Oracle Security Training Courses
Cookie Policy:We only use essential cookies on small sections of this website. For details see here.

Welcome, Guest. Please Login.
Oct 26th, 2020, 7:53pm
News: Welcome to Pete Finnigan's Oracle security forum
Home | Help | Search | Members | Login
   Pete Finnigan's Oracle Security Forum
   Oracle Security
   Oracle Security
(Moderator: Pete Finnigan)
   Oracle Rootkit 2.0: pinning ?
« Previous topic | Next topic »
Pages: 1  Reply | Notify of replies | Send Topic | Print
   Author  Topic: Oracle Rootkit 2.0: pinning ?  (Read 2044 times)
Pete Finnigan
PeteFinnigan.com Administrator
*****




Oracle Security is easier if you design for it

   
View Profile | WWW | Email

Gender: male
Posts: 309
Oracle Rootkit 2.0: pinning ?
« on: Jul 19th, 2007, 9:07am »
Quote | Modify

hello all & Alex.
 
I read the whitepaper about "Oracle Rootkit 2.0", and i think the ideas about PINNING is not correct:
"Changed objects are NOT automatically reloaded if they are changed."
 
As I know, Oracle will reload automatically when PINED object is changed.
 
Would i miss something. Please, help me clarify it.
 
sys@TEST> create or replace function f1 return number is  
  2  begin
  3     return 1;
  4  end;
  5  /
 
Function created.
 
sys@TEST> select f1 from dual
  2  /
 
   F1
----------
    1
 
sys@TEST> exec sys.dbms_shared_pool.keep('F1')
 
PL/SQL procedure successfully completed.
 
sys@TEST> select name, pins, kept from v$db_object_cache where name='F1'
  2  /
 
NAME        PINS   KEP
------------------------------ ---------- ---
F1         0  YES
 
sys@TEST> create or replace function f1 return number is  
  2  begin
  3     return 3;
  4  end;
  5  /
 
Function created.
 
sys@TEST> select f1 from dual
  2  /
 
   F1
----------
    3     <== It's 3, not 1
 
sys@TEST>
 
IP Logged

Pete Finnigan (email:pete@petefinnigan.com)
Oracle Security Web site: http://www.petefinnigan.com
Forum: http://www.petefinnigan.com/forum/yabb/YaBB.cgi
Oracle security blog: http://www.petefinnigan.com/weblog/entries/index.html
Pages: 1  Reply | Notify of replies | Send Topic | Print

« Previous topic | Next topic »

Powered by YaBB 1 Gold - SP 1.4!
Forum software copyright 2000-2004 Yet another Bulletin Board