Anyone has an idea why a user login in one of my databases got suddenly deleted
The user was working okay around 8 Am and suddenly at 9 AM he was disconeccted from the system
After reviewing what went wrong, I noticed his account was no longer in the database users
All I did was to add the account, but why did this happened? I am worried since the system works 24 hrs a day
Any advice
Thank you.I've never heard of such thing ever happened. I'd suspect someone or a
program executed sp_revokedbacces and/or sp_revokeloing/sp_droplogin.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Daniel Roche" <dan_rb@.hotmail.com> wrote in message
news:F16F11F1-3FDB-45A0-B58F-BD4269B6B873@.microsoft.com...
> Anyone has an idea why a user login in one of my databases got suddenly
deleted?
> The user was working okay around 8 Am and suddenly at 9 AM he was
disconeccted from the system.
> After reviewing what went wrong, I noticed his account was no longer in
the database users.
> All I did was to add the account, but why did this happened? I am worried
since the system works 24 hrs a day.
> Any advice?
> Thank you.|||Is there a possibility that the database was restored at 9 AM?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Daniel Roche" <dan_rb@.hotmail.com> wrote in message
news:F16F11F1-3FDB-45A0-B58F-BD4269B6B873@.microsoft.com...
Anyone has an idea why a user login in one of my databases got suddenly
deleted?
The user was working okay around 8 Am and suddenly at 9 AM he was
disconeccted from the system.
After reviewing what went wrong, I noticed his account was no longer in the
database users.
All I did was to add the account, but why did this happened? I am worried
since the system works 24 hrs a day.
Any advice?
Thank you.
