RocketScientist's Miscellaneous Ramblings
posts - 76, comments - 354, trackbacks - 3

Security Request

OK, anybody have any idea why I can't say that certain users are only allowed to log into my server from specific workstations? I'd really love to say that my web login (the logn my web site logs in with) can only log in from my web servers, and if any of my developers tried to use it they'd either get an error message or be electrocuted (preferably at random). I mean, come on, even a hosts.allow or hosts.deny set of files would be an easy to manage cheap to implement security layer. Otherwise, I've got to, what rely on a firewall or something and then have it filter by IP? Sucktastic.

Yeah, I can probably administer it from Windows (i.e. only allow the user to login to specific workstations) but then I have to have some system administrator deal with it, when it would be much easier if I could do it myself. Plus that would limit me to limiting only integrated security logins and not standard security ones.

Print | posted on Tuesday, November 04, 2003 2:10 PM |



# re: Security Request

You could create an application role for the application to use. This however still doesn't get you you're goal of allowing it on an IP basis, however it is now controlled on a per application basis. For more information check out the BOL entry for SQL Server of "Establishing Application Security and Application Roles" @
11/4/2003 3:06 PM | Aaron Weiker

# re: Security Request

I'd thought about that.

App Roles are fairly complicated to set up, and not nearly as easy to deal with as a simple hosts.allow or hosts.deny-type system. Developers would have to come up with some way to hide the role password, at which point it wouldn't buy me anything to have the role password because the developers would be able to use the role, and they're the ones I need per-user auditing for. Bear in mind, I don't care if the developers are in the database, I just want them in with their own logins so I can track activity.

Basically, application roles wouldn't work to prevent mis-use of the web server account, so it's not what I need to solve the problem.

Plus, think about all of the other security problems this would patch. As long as the server has some kind of IP-Spoofing protection, then you can kiss goodbye all of the port 1433-related vunerabilities, like the slammer worm exploited. If you can only connect from approved addresses, it's like having a very simple mini-firewall, without having to figure out the port-blocking in Windows.

11/4/2003 3:49 PM | rocketscientist

# re: Security Request

I like your hosts.allow/deny idea. Don't think I've heard anything new in the login/security area for Yukon. But hey, you could always come to PASS and "Ask the Experts". *grin*

Or, here's an idea we considered once. Never pursued it completely, so there may be some loose ends, but what about using the servername\iweb_XXXX user as your web login to SQL Server? That may not work if you have a web server farm. But I think it would handle your "limit to this machine" problem.
11/5/2003 9:44 AM | AjarnMark
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET