cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
Carlos_PTL
Calcite | Level 5 Carlos_PTL
Calcite | Level 5

Connect to OLEDB Trouble

Posted 09-11-2007 02:16 PM (577 views)
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?
0 Likes
Reply

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Watch SAS Enterprise Guide vs. SAS Studio on YouTube

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 0 replies
  • ‎09-11-2007 02:16 PM
  • 578 views
  • 0 likes
  • 1 in conversation