Re: SQL injection

[Josh Zlatin-Amishav <josh () tkos co il>]

On Sun, 16 Jan 2005, Francesco wrote:

> I have just discovered that I can successfully inject the following SQL:
>
> ' OR 1=1; --
>
> into the Username field of a logon form on a "secure" site in my
> corporate network (Windows 2000, SQL 7.0).  When I do this, leaving the
> password field blank, I am logged into the system as the first user in
> the "Users" table in the DB which is being authenticated against.  LOL.
>
> If I can get that far, can't I theoretically:
>
> ' OR 1=1; DELETE Users; --
>
> or something similar?  Couldn't I EXEC some system sprocs this way too?
> How much damage/rooting can be done here?  I need to present a detailed
> report to the admins.

Hi Francesco,
That all depends on the permissions that the user you are acting as has.
In your case it depends on the permissions of the first user in the
"Users" table.

> Thanks,
>
> Francesco
> Francesco Sanfilippo
> -------------------------------------------
> Blackcoil Productions - http://blackcoil.com
> URL123 Link Service - http://url123.com

--
  - Josh

GPG: 445F 7FB3 3D99 EE8C 99A4  4313 352D FFD4 02B2 C7F3