snip
Also, if you're trying to prevent your customers from access the data outside of your application, there is merit to that. I've had many occurances where customers have used Access to manually manipulate the data and cause havoc. On The Other Hand, the data usually belongs to the customer and they might want access to it in order to do things that your app may not provide out of the box. One of the benefits of SQL Server, In my opinion, is that I can give my customer read-only or limited-write access to their data and enforce it via the database engine instead of my application.
Correct, But I do not want to expose the application tables.
I expose usr.Views,usr.sp_xx only, in order to allow customers direct access.
By the way, MS hasn't shipped SQL Server 2005 yet. You could always send this as a enhancement request: sqlwish@microsoft.com is the email address I believe.
Thank Michael