Is it possible to block a sql server auth. user not to execute ddlDDL and dmlDML operations onfrom a spesificspecific hostname (client)?
I have a CRM web application. That app connects to my database with a sql server auth user. There are several different developers working on that CRM web app. They know the user name and password from the web config file they develop. Some of them can connect to my database with that user and execute some DDL and DML commands and I want to block them by their client hostname. If a developer connects to db from his/her machine with the app user credential, I want to block them.
