Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
callawayx14
Yak Posting Veteran
73 Posts |
 Posted - 2014-05-21 : 11:25:31
|
| Hello I’m connecting to a SQL Server (2008r2) via SSMS from two separate machines using the same credentials.On machine 1 SSMS (2008r2): I can view the tables under a specific database in On machine 2 SSMS (2008): I can only view the system tables under the same db in I’ve refreshed the Server, DB and Tables (F5)I’ve rebooted machine 2.I cannot figure this out. Very frustratingI appreciate any help |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-06-12 : 19:27:45
|
Sounds like a rights issue. Can you issue this grant and see if it resolves the symptom?GRANT VIEW DEFINITION TO [MyUser];
Too often we enjoy the comfort of opinion without the discomfort of thought. - John F. Kennedy |
 |
|
|
|
|
|
SSMS - Cannot View Tables