Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 261
  • Last Modified:

Unable to see Database tables in SQL Mgmt Studio

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
teknite
Asked:
teknite
1 Solution
 
Surendra NathTechnology LeadCommented:
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
 
tekniteAuthor Commented:
Thanks for your quick response.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now