How database users see their objects in sql server
Sounds like you need to employ some database schemas to separate out user objects:

http://msdn.microsoft.com/en-us/library/ms190387.aspx

A database schema is nothing more than a collection of objects within a database.  DBO and SYS are common built-in schemas in SQL Server.  You can create a schema that houses a user's objects (tables, functions, stored procs . . .) and assign a level of security to that schema (owner, reader . . . ).  These help especially in terms of object-level administration.