You can set up a trace for this and filter it by selected logins. Or you might be able to use the SQL 2008 audit feature: http://msdn.microsoft.com/en-us/library/dd392015.aspx