I like stored procedures as they both restrict the ways the database is accessed and are completely testable units themselves. Working against views makes sense to me but possibly unnecessary if access is only allowed via stored procedures. Either way (SPs or views) they provide a logical view over and above tables.