alert or trigger on create login

Question

Viewing 5 posts - 1 through 4 (of 4 total)

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

dbafromthecold@gmail.com SSChampion Points: 10160 More actions · Answer 1

Hi,

Yes you can setup a DDL trigger to fire when a CREATE LOGIN is executed. Have a look here:-

Andrew

tutupouet SSCommitted Points: 1512 More actions · Answer 2

thank you Andrew,

I had looked but I hadn't seen the event "CREATE_LOGIN" !!!

:blush:

Geoff A SSChampion Points: 11511 More actions · Answer 3

you can get that info from the default trace (if it is running)

to be alerted would require you to set up an agent job that parsed the default trace at a set interval looking for new values in TargetLoginName

declare @mytrclocal sql_variant

set @mytrclocal = (SELECT value FROM sys.fn_trace_getinfo(NULL) WHERE property= 2)

select * from fn_trace_gettable(convert(varchar(500),@mytrclocal), default)

where TargetLoginName is not NULL

Geoff A SSChampion Points: 11511 More actions · Answer 4

SSChampion

Points: 11511

July 19, 2013 at 6:15 am

double post...