add new users to security
-
HI. I just noticed some users in sql security that I do not recall adding. Is there a way I can tell who added these logins and when? There is no database checked off with these logins.
Juanita
-
I don't think you could tell who unless you have the tlogs for the dates that the creation happened and you have a tool like logexplorer or entegra
the good news is that you may be able to tell when just run:
select createdate, updatedate from master.dbo.syslogins where loginname like 'suspicioslogin'
* Noel -
Thank you I will try the select stmt. But I do have logexplorer. I have not used it much but I guess now is a good a time as any.I guess I would look at the MASTER logs?
Juanita
-
Well it was all done in 1 shot it looks like back in February. I don't think logexplorer will help me in this case. But thank you so much for the sql code. If the logins are not associated with a DATABASE, it would seem as though they cannot be being used.
Juanita
-
Yep it is pretty much too late for logexplorer but not too late for entegra which would archive it sepparately
about the
"If the logins are not associated with a DATABASE, it would seem as though they cannot be being used. "
well not now but what if at that time they were associated and then cleared?
* Noel -
You have a point.. well i'm just going to delete them and I guess if someone needs them they'll HOLLER !!
THANK YOU for all your help !!
Juanita
-
Sure! it is what I would do
* Noel -
HI. Me again, I did a select * so I could see all fields for that login. there is a field called STATUS. Would you know what that field represents?
Juanita
-
this is supposed to be for internal use but...
I can anticipate that x0802 means has haccess x0801 -- Does not 
this should not be the way you check that because there are other functions "documented" to get that info
hth
* Noel -
okay, thanks a bunch !
Juanita
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply