RE: Oracle SQL Injection vulnerability

["Erin Carroll" <amoeba () amoebazone com>]

Yes. The application isn't escaping special characters in the input field
and is executing the input as a statement. Try a username of %' or a name
like 'admin% and see what you get back. If you're lucky you'll get an error
message but the following statement will be executed "“select id, user_role
from users where name='%' OR NAME LIKE 'ADMIN%'” Ïnjecting SQL commands
without having a valid user account is a pretty severe issue and you should
suggest to your client to set explicit input parameters (A-z, 0-9) and
escape special characters using whichever method applies to their codebase. 

You can leverage several tools out there to test further. Off the top of my
head there's SQLNinja, Absinthe, FJ-Injector Framework, NGSS SQL Injector,
and many others.

I'm sure others on the list will have some other suggestion or tips, this
was just a quick response off the cuff.

--
Erin Carroll
Moderator
SecurityFocus pen-test list
"Do Not Taunt Happy-Fun Ball" 

> -----Original Message-----
> From: listbounce () securityfocus com 
> [mailto:listbounce () securityfocus com] On Behalf Of Attari Attari
> Sent: Monday, November 19, 2007 1:32 AM
> To: pen-test () securityfocus com
> Subject: Oracle SQL Injection vulnerability
>
> Hi Group,
>
> I'm doing a penetration test for a client on their web 
> portal. When I give ' on the username field I was received 
> with an error from the server:
>
> Unspecified error
> ORA-01756: quoted string not properly terminated 
>
> Does that mean the site is vulnerable to SQL Injection? I 
> tried ' OR 1=1-- and ' OR '1'='1'-- but I get same error message.
>
> Any help would be much appreciated.
>
> Clone
>
>
>       Meet people who discuss and share your passions. Go to 
> http://in.promos.yahoo.com/groups
>
>
> --------------------------------------------------------------
> ----------
> This list is sponsored by: Cenzic
>
> Need to secure your web apps NOW?
> Cenzic finds more, "real" vulnerabilities fast.
> Click to try it, buy it or download a solution FREE today!
>
> http://www.cenzic.com/downloads
> --------------------------------------------------------------
> ----------


------------------------------------------------------------------------
This list is sponsored by: Cenzic

Need to secure your web apps NOW?
Cenzic finds more, "real" vulnerabilities fast.
Click to try it, buy it or download a solution FREE today!

http://www.cenzic.com/downloads
------------------------------------------------------------------------