Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

User Access to sql server Expand / Collapse
Author
Message
Posted Monday, April 30, 2007 1:24 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 22, 2014 1:20 PM
Points: 20, Visits: 252

Is there a way to identify users within SQL Server that have not accessed a database within 30 days?

 

Samuel

Post #362096
Posted Tuesday, May 1, 2007 8:51 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, August 25, 2014 9:03 AM
Points: 486, Visits: 1,221

Easily.... No. 

You can enable the "Audit-Level" server property to record logins in the SQL Server log and Windows Application Event Log.  Then you would have to parse and analyze these logs to get what you're after.

You could also use the SQL Profiler in a similar fashion.

The C2 level auditing available in SQL Server is probably way overkill for you.

Then there are some third party tools available from companies like Idera.

Here is a link with some further discussion:

http://sqljunkies.com/Forums/ShowPost.aspx?PostID=11184#11189

 




Post #362302
Posted Monday, May 7, 2007 2:49 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 22, 2014 1:20 PM
Points: 20, Visits: 252

Thanks you

Post #363818
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse