Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Blocking application using policy management? Expand / Collapse
Author
Message
Posted Saturday, August 4, 2012 5:45 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 6, 2013 12:31 PM
Points: 1, Visits: 103
We are starting to dabble with policy management where I work, and I was wondering if anyone would know if there is a way to block a particular application from accessing the database server?

I know you can restrict access based on login, but I was wondering if there is a way to prevent office applications from connecting. I know that I could put in a trigger to do this, but I was thinking that policy management should be the way to go.

We started going through the facets to try to find application name, but haven't stumbled upon it yet.

Thanks!!!
Post #1340229
Posted Sunday, August 5, 2012 7:14 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 8:30 AM
Points: 907, Visits: 1,898
I'm not sure if you can do this via policy managment. IMO access to a database should be a part of a well thought out security configuration, and I don't think that fully falls under policy managment, but I guess it's a grey area.

Ideally though only application service accounts and a select few users (if any) should have access to the database server. This way the majority of users don't have direct access and your problem of users connecting to the database by other applications becomes moot.
Post #1340266
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse