How do I restrict users from viewing my schema?

[ja...@ldcdirect.com]

I am designing an application where I need my users to interface with the
database using stored procedures and I do not want them to view my database
schema.

Unfortunately when I grant EXECUTE access to the user for the stored procedure
they also gain the ability to view my database schema using SQL Enterprise
Manager. Is there a way to allow a user the ability to access a stored
procedure and not view the schema/triggers/etc of the underlying tables?

Any assistance would be greatly appreciated.

-- James A. White
-- LDC Direct

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/ Now offering spam-free web-based newsreading