Oracle DB Privilege Escalation via Function-Based Index - Metasploit


This page contains detailed information about how to use the auxiliary/admin/oracle/oracle_index_privesc metasploit module. For list of all metasploit modules, visit the Metasploit Module Library.

Table Of Contents
hide

Module Overview

Name: Oracle DB Privilege Escalation via Function-Based Index
Module: auxiliary/admin/oracle/oracle_index_privesc
Source code: modules/auxiliary/admin/oracle/oracle_index_privesc.rb
Disclosure date: 2015-01-21
Last modification time: 2020-10-02 17:38:06 +0000
Supported architecture(s): -
Supported platform(s): -
Target service / protocol: -
Target network port(s): 1521
List of CVEs: -

This module will escalate an Oracle DB user to DBA by creating a function-based index on a table owned by a more-privileged user. Credits to David Litchfield for publishing the technique.

Module Ranking and Traits

Module Ranking:

  • normal: The exploit is otherwise reliable, but depends on a specific version and can't (or doesn't) reliably autodetect. More information about ranking can be found here.

Basic Usage

msf > use auxiliary/admin/oracle/oracle_index_privesc
msf auxiliary(oracle_index_privesc) > show targets
    ... a list of targets ...
msf auxiliary(oracle_index_privesc) > set TARGET target-id
msf auxiliary(oracle_index_privesc) > show options
    ... show and set options ...
msf auxiliary(oracle_index_privesc) > exploit

Knowledge Base

Vulnerable Application

  1. Install Oracle Database
  2. Insert the "Scott/Tiger" test data

Verification Steps

  1. Install the application
  2. Connect via sqlplus, and check current privileges:
    1. Ex: sqlplus SCOTT/[email protected]:1521/XEXDB
    2. Ex: SELECT * FROM session_privs
  3. Start msfconsole
  4. Do: use auxiliary/admin/oracle/oracle_index_privesc
  5. Do: set SQL, and TABLE if desired
  6. Do: exploit
  7. Reconnect with sqlplus and check privileges post-exploit:
    1. Ex: sqlplus SCOTT/[email protected]:1521/XEXDB
    2. Ex: SELECT * FROM session_privs

Options

SQL

The SQL that will execute with the privileges of the user who created the index. Default is to escalate privileges.

TABLE

Table to create the index on.

Go back to menu.

Msfconsole Usage

Here is how the admin/oracle/oracle_index_privesc auxiliary module looks in the msfconsole:

msf6 > use auxiliary/admin/oracle/oracle_index_privesc

msf6 auxiliary(admin/oracle/oracle_index_privesc) > show info

       Name: Oracle DB Privilege Escalation via Function-Based Index
     Module: auxiliary/admin/oracle/oracle_index_privesc
    License: Metasploit Framework License (BSD)
       Rank: Normal
  Disclosed: 2015-01-21

Provided by:
  David Litchfield
  Moshe Kaplan

Check supported:
  No

Basic options:
  Name    Current Setting     Required  Description
  ----    ---------------     --------  -----------
  DBPASS  TIGER               yes       The password to authenticate with.
  DBUSER  SCOTT               yes       The username to authenticate with.
  RHOST                       yes       The Oracle host.
  RPORT   1521                yes       The TNS port.
  SID     ORCL                yes       The sid to authenticate with.
  SQL     GRANT DBA to SCOTT  yes       SQL to execute.
  TABLE   SYS.DUAL            yes       Table to create the index on.

Description:
  This module will escalate an Oracle DB user to DBA by creating a 
  function-based index on a table owned by a more-privileged user. 
  Credits to David Litchfield for publishing the technique.

References:
  http://www.davidlitchfield.com/Privilege_Escalation_via_Oracle_Indexes.pdf

Module Options

This is a complete list of options available in the admin/oracle/oracle_index_privesc auxiliary module:

msf6 auxiliary(admin/oracle/oracle_index_privesc) > show options

Module options (auxiliary/admin/oracle/oracle_index_privesc):

   Name    Current Setting     Required  Description
   ----    ---------------     --------  -----------
   DBPASS  TIGER               yes       The password to authenticate with.
   DBUSER  SCOTT               yes       The username to authenticate with.
   RHOST                       yes       The Oracle host.
   RPORT   1521                yes       The TNS port.
   SID     ORCL                yes       The sid to authenticate with.
   SQL     GRANT DBA to SCOTT  yes       SQL to execute.
   TABLE   SYS.DUAL            yes       Table to create the index on.

Advanced Options

Here is a complete list of advanced options supported by the admin/oracle/oracle_index_privesc auxiliary module:

msf6 auxiliary(admin/oracle/oracle_index_privesc) > show advanced

Module advanced options (auxiliary/admin/oracle/oracle_index_privesc):

   Name       Current Setting  Required  Description
   ----       ---------------  --------  -----------
   VERBOSE    false            no        Enable detailed status messages
   WORKSPACE                   no        Specify the workspace for this module

Auxiliary Actions

This is a list of all auxiliary actions that the admin/oracle/oracle_index_privesc module can do:

msf6 auxiliary(admin/oracle/oracle_index_privesc) > show actions

Auxiliary actions:

   Name  Description
   ----  -----------

Evasion Options

Here is the full list of possible evasion options supported by the admin/oracle/oracle_index_privesc auxiliary module in order to evade defenses (e.g. Antivirus, EDR, Firewall, NIDS etc.):

msf6 auxiliary(admin/oracle/oracle_index_privesc) > show evasion

Module evasion options:

   Name  Current Setting  Required  Description
   ----  ---------------  --------  -----------

Go back to menu.

Error Messages

This module may fail with the following error messages:

Error Messages

Check for the possible causes from the code snippets below found in the module source code. This can often times help in identifying the root cause of the problem.

Error! <E.MESSAGE>

Here is a relevant code snippet related to the "Error! <E.MESSAGE>" error message:

75:	      prepare_exec(clean_index)
76:	      print_status('Cleaning up function...')
77:	      prepare_exec(clean_func)
78:	      print_status('Exploit complete!')
79:	    rescue ::OCIError => e
80:	      print_error("Error! #{e.message}")
81:	    end
82:	  end
83:	
84:	  def prepare_exec(query)
85:	    print_status(query)

Go back to menu.

References

See Also

Check also the following modules related to this module:

Authors

  • David Litchfield
  • Moshe Kaplan

Version

This page has been produced using Metasploit Framework version 6.1.36-dev. For more modules, visit the Metasploit Module Library.

Go back to menu.