Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Unable to see Database tables in SQL Mgmt Studio

Posted on 2013-06-20
2
Medium Priority
?
257 Views
Last Modified: 2013-06-20
HI,

I have recently created a new user for a client on their server. This user remotes onto the server using RDP and acesses the SQL mgmt studio to see the database and more specifically the tables.

The problem I have is the user can log on, access SQL but when going to see the tables, nothing is listed.

I created a user account in SQL just like the other user accounts, but this user can't see any tables but the other users can.

Any assistance in this annoying problem would be great. They are using SQL 2005

Thanks
0
Comment
Question by:teknite
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Accepted Solution

by:
Surendra Nath earned 2000 total points
ID: 39264135
Ensure that the user have the role of db_dataReader
http://msdn.microsoft.com/en-us/library/ms188629%28v=sql.90%29.aspx

The below link will help you in setting the user role (although it is pretty old, it might be a good quick start).

http://www.techrepublic.com/article/understanding-roles-in-sql-server-security/1061781
0
 

Author Closing Comment

by:teknite
ID: 39264351
Thanks for your quick response.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question