Prev Reference Question: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/a6166b82-1e1a-4771-952d-a7b54e0b0f23?prof=required
I see the same problem with SQL 2008 Management Studio. I have different schema defined in my database, all the schema permissions work just fine in SQL 2005 but when viewed from SQL 2008. I cannot see tables for which i have given inidividual permissions. I have given SELECT permissions for those tables.
schema: dbo, schema1, schema2 ....
user: user1 (schema1 owner), user2 (schema2 owner), user3 ...
now i have given SELECT on schema1.table1 to user2
this works fine and i m able to see the schema1.table1 when login as user2 in SQL2005. I have tried your solution for giving "View Definition" permission as well. But this doesnt work in my case.
Seems to be some default permission settings with SQL 2008 ??
Any help/Suggestion will be appreciated
View Complete Post