|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SA LoginHi,
Is there a way that I can be notified whenever someone successfully logs in as SA? Thanks, Terry Terry,
It can be done. I answered a similar question a while ago, which you can view here: http://tinyurl.com/6ugfo -- Show quoteMark Allison, SQL Server MVP http://www.markallison.co.uk Looking for a SQL Server replication book? http://www.nwsu.com/0974973602m.html nospam@brothersfamily.net wrote: > Hi, > > Is there a way that I can be notified whenever someone successfully logs in > as SA? > > Thanks, > Terry nospam@brothersfamily.net wrote:
> Hi, How about changing the password on "sa" so no one uses it at all. It's a > > Is there a way that I can be notified whenever someone successfully > logs in as SA? > > Thanks, > Terry much better idea to grant specific users admin rights should they require them and use Windows Authentication. Even if you use SQL Security, you'll at least know who the admin is that is attached. It's a good idea to secure the "sa" account and have no one use it. Put a really obnoxious password on the account and store the password in the company safe. Good advice David, however I would still recommend such an alert in
place in case the authentication mode gets changed from trusted to non-trusted and someone tries to log in with sa. You the OP may also want a failed login for sa alert too. -- Show quoteMark Allison, SQL Server MVP http://www.markallison.co.uk Looking for a SQL Server replication book? http://www.nwsu.com/0974973602m.html David Gugick wrote: > nospam@brothersfamily.net wrote: > >> Hi, >> >> Is there a way that I can be notified whenever someone successfully >> logs in as SA? >> >> Thanks, >> Terry > > > How about changing the password on "sa" so no one uses it at all. It's a > much better idea to grant specific users admin rights should they > require them and use Windows Authentication. Even if you use SQL > Security, you'll at least know who the admin is that is attached. It's a > good idea to secure the "sa" account and have no one use it. Put a > really obnoxious password on the account and store the password in the > company safe. > Good advice David, however I would still recommend such an alert in
place in case the authentication mode gets changed from trusted to non-trusted and someone tries to log in with sa. You the OP may also want a failed login for sa alert too. -- Show quoteMark Allison, SQL Server MVP http://www.markallison.co.uk Looking for a SQL Server replication book? http://www.nwsu.com/0974973602m.html David Gugick wrote: > nospam@brothersfamily.net wrote: > >> Hi, >> >> Is there a way that I can be notified whenever someone successfully >> logs in as SA? >> >> Thanks, >> Terry > > > How about changing the password on "sa" so no one uses it at all. It's a > much better idea to grant specific users admin rights should they > require them and use Windows Authentication. Even if you use SQL > Security, you'll at least know who the admin is that is attached. It's a > good idea to secure the "sa" account and have no one use it. Put a > really obnoxious password on the account and store the password in the > company safe. > Terry,
It can be done. I answered a similar question a while ago, which you can view here: http://tinyurl.com/6ugfo -- Show quoteMark Allison, SQL Server MVP http://www.markallison.co.uk Looking for a SQL Server replication book? http://www.nwsu.com/0974973602m.html nospam@brothersfamily.net wrote: > Hi, > > Is there a way that I can be notified whenever someone successfully logs in > as SA? > > Thanks, > Terry  |
|||||||||||||||||||||||
Other interesting topics