Timeline for Deny a Sql Server user from a specific hostname
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 3, 2020 at 7:20 | comment | added | DBA | Alright, Is it possbile block them according to their AD accounts instead of a client hostname or ip address? I mean, Can i define a rule like ' if a sql server username is an app name and the hostname from an AD group account then block that connection' in sql server? | |
| Jan 2, 2020 at 14:01 | comment | added | Yannick Liekens | Could probably look into a solution where your devs cannot see the login/password themselves. If they connect to the database, they should use their own dev logins. Setting that up (correctly) would be out of my field of expertise I'm afraid. | |
| Jan 2, 2020 at 13:52 | comment | added | DBA | Yep. Unfortunately, that user has to have those rights. 'Cause, customer representatives use this CRM application and they don't know sql and shouldn't. :/ | |
| Jan 2, 2020 at 12:28 | history | answered | Yannick Liekens | CC BY-SA 4.0 |