January 20, 2009 at 11:22 am
Guys,
I want to restrict a database user that I created to be accessing database/run scripts only from one machine. This user should not be able to access the database from any other machines. Is there any way to accomplish this? Also is there anyway to restrict the user to use only certain type of connections. For example I do not want the user to access the database from Management Studio.
Any suggestions and inputs would help.
Thanks
January 20, 2009 at 11:38 am
A login trigger can handle that kind of thing, but be very, very careful about how you write it, because mis-creating one of those can do really bad things, like block everyone from getting into the server, including you. Done correctly, properly tested, it should be okay.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply