开发者

Sql server management studio 2008: what permissions are necessary to display table list?

In SSMS 2008, when I expand the tables folder, all i see is the "System Tables" folder.

In SSMS 2005, when I connect to the exact same database with same account, I expand the tables folder and see all my tables. Has something changed with which tables are displayed by default? Does it o开发者_如何转开发nly show tables in the default schema by default?


found that it was related to my user account not having select permssions on some SYS objects as well as select access to the owner of the tables

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜