Post reply

Deny write access from certain host?

  • January 31, 2007 at 10:07 am

    #90945

    Hi!

    Is it possible to deny write access from certain host?

    I have a webserver and I would like to, regardless of what user account is used deny write to my database from that host.

    My database is on another server and I'm building a webapplication to access it.

    Using SQL Server 2000.

  • February 1, 2007 at 2:19 am

    #687041

    Only thing I can think of would be to write triggers for ALL tables for all UPDATE/INSERT/DELETE statements to disallow same when the user comes from a specific IP/HOSTNAME.

  • February 5, 2007 at 12:36 am

    #687678

    Ok. Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply