Groups | Blog | Home
all groups > iis security > june 2006 >

iis security : System Stored Procedures



Eng.Rana NO[at]SPAM gmail.com
6/15/2006 12:10:38 AM
Hello All,
i was wondering if there exists some way to disable all system stored
procedures, as they are vulnerable to attacks specially if they r not
needed within any of my applications.
something like, xp_cmdshell may cause attacks.

i need ur help plz and will appreciate ur response and suggestions

thanx for ur gr8 help
Roger Abell [MVP]
6/15/2006 4:04:26 PM
See my response to your identical post elsewhere.
Is there some specific sys sproc that concerns you ?

[quoted text, click to view]

Ken Schaefer
6/15/2006 4:44:05 PM
You simply set permissions on those system stored procs. Then you ensure
that your applications connect using other credentials.

That is how you secure your server against cmd.exe from being abused (i.e.
by setting ACLs on cmd.exe), and cmd.exe is basically what you get when
using xp_cmdshell.

Cheers
Ken

[quoted text, click to view]

Eng.Rana NO[at]SPAM gmail.com
6/15/2006 10:59:41 PM

[quoted text, click to view]


what if i want to protect my server from allllllll the system stored
procedure not only xp_cmd.exe.

there exists manyyyyyyy system stored procedures that may be used in a
malicious way to attack my server and it will be impossible to change
permissions to al these stored procedures :)

so,, what do u think??
Roger Abell [MVP]
6/16/2006 4:34:16 AM
Name some of these, but not one that may but rather that can be
used to attack your server in malicious way by a SQL user that is
not in any of the Server Roles.

I think you are chasing ghosts.

Roger Abell
(MCDBA and Windows Server Security MVP)

[quoted text, click to view]

AddThis Social Bookmark Button