Hello,
I'd like to hide database design to developpers and allow access to data only by a set of stored procs.
I want to avoid direct "SELECT * FROM" by the apps code.
In fact, I don't care about coders knowing the database structure, only not allow them to code by bypassing my interface encapsulating layer.
How can I do this neatly ?
(I'm using SQL Server 2005)
Thanks
I'd like to hide database design to developpers and allow access to data only by a set of stored procs.
I want to avoid direct "SELECT * FROM" by the apps code.
In fact, I don't care about coders knowing the database structure, only not allow them to code by bypassing my interface encapsulating layer.
How can I do this neatly ?
(I'm using SQL Server 2005)
Thanks