In SQL server 2008 we have 30 users schemas setup under a single database (say "UserDB")
Each user is set up with access to his/her own schema
So when you login to server and drill down to Databases >>UserDb >> Tables,
you will see the tables that belong to your schema
Now I have to give cross Schema access. User 1 wants to see User 2's schema tables.
User 1 tables shows up as user1.table1 and user 2 tables show up as user2.table2
Question is: Instead of listing ALL the tables, differentiated by prefix, is there a way to show them like windows folders.
View Complete Post