Hello,
How can I audit users logins to particular database? Can I audit to a file or to database?
Any help is appreciated.
Thanks
Priti
Printable View
Hello,
How can I audit users logins to particular database? Can I audit to a file or to database?
Any help is appreciated.
Thanks
Priti
I prefer auditing on a table so that i can query it easily.
To audit for a particular database, in the profiler filter it for database name.
Check Profiler properties.
I believe you are using SQL Server.
I'm using SQL Server 7.0 I would appreciate if you could guide me what events should I use to get the login info of particular database, All the tables are sensitive on that db,should I save the output to file or to database?
Thanks A lot
If you are concerned about only logins, then use security audit in the event list. Store it in a database table