hidden schema

[Ebube]

how can i hide sqlsever database. still allowing my application to connect to it. that is users cannot be able to view the db object with user name and password in the web configure. i have been using shema approach but is given a lot of deployment issue

[dan sh]

Denying "View Database Definition" permission to the user might just do that. Not sure though.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD