Delete Trigger

Question

Delete Trigger

Viewing 4 posts - 16 through 18 (of 18 total)

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

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 1

Jan Van der Eecken (6/18/2012)
Evil Kraig F (6/18/2012)
Jan Van der Eecken (6/18/2012)
Oops, I misspelled your name. Apologies, Kraig!
LOL, at this point, either is acceptable. 😉 :w00t:
It just depends on which of the twins you want to talk to... the evil one with his goatee or his occassionally shaved good brother. 😎
Now which one of the two is you? I wouldn't mind shaving either.
Got twins too, younger ones. One of them certainly doesn't need shaving. 😉

Ah, you were, I guess, absent when this started. Originally someone mispelled my name, Craig, as Kraig... while quoting me so it was in the header line. It became a short running joke and eventually I decided I could be my own Evil Twin, so I changed my display name. 😎

The correct spelling is always in my signature. 🙂

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

Jan Van der Eecken SSCrazy Eights Points: 9029 More actions · Answer 2

Evil Kraig F (6/18/2012)
Jan Van der Eecken (6/18/2012)
Evil Kraig F (6/18/2012)
Jan Van der Eecken (6/18/2012)
Oops, I misspelled your name. Apologies, Kraig!
LOL, at this point, either is acceptable. 😉 :w00t:
It just depends on which of the twins you want to talk to... the evil one with his goatee or his occassionally shaved good brother. 😎
Now which one of the two is you? I wouldn't mind shaving either.
Got twins too, younger ones. One of them certainly doesn't need shaving. 😉
Ah, you were, I guess, absent when this started. Originally someone mispelled my name, Craig, as Kraig... while quoting me so it was in the header line. It became a short running joke and eventually I decided I could be my own Evil Twin, so I changed my display name. 😎
The correct spelling is always in my signature. 🙂

I know 😉

--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 3

Jan Van der Eecken (6/18/2012)
I know 😉

Mmmmm... tasty foot. Anyone want a bite? :pinch:

One of those days... :Whistling:

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

vikingDBA SSCertifiable Points: 5356 More actions · Answer 4

You could capture the HOST_NAME(). This gives the computer name that the user was on.

I use this. Works great.

Don't know if this gives you enough information to go on, though. Does in our case.

Does the user know the username and password to the SQL authenticated login that the app uses? I assume that is the only way they can get back in and do stuff. If so, try to mitigate that issue.

Maybe a better thing do is have a logon trigger that only lets that username use the application that it is supposed to.

Here is a link that explains that.

http://www.sqlservercentral.com/scripts/Security/69558/

That way, if they are using SSMS or any other application, and using that username, it won't let them log in.

TEST THIS ON A DEV BOX FIRST! THIS COULD BE DANGEROUS, especially if you are new to logon triggers!