Desktop productivity for business analysts and programmers

Connect to OLEDB Trouble

Reply
N/A
Posts: 1

Connect to OLEDB Trouble

Hi, I have an user created in Microsoft Sql Server using a System Administrator Role. In Enterprise Guide 4.1, When I try to create an oledb library, I can see all the tables in the default database, everything works!!.

My problem happens when I change the Role of my user (in sqlserver) by db_datareader role, after that, when I try to create the library in Enterprise Guide, I can not see any table, but If I want to check this permissions in Sql server Query Analyzer, everything works, I see all the tables in the database.

Could you pls help me with this issue?
Ask a Question
Discussion stats
  • 0 replies
  • 82 views
  • 0 likes
  • 1 in conversation