I am using SAS EG 9.1.
When I am connecting new library, that is MS SQL 2000 database via ODBC, I cant see tables in data window. I can connect to it via proc sql, but I cant see it on the library tree list like in other sources.
Only when I put dbo (database owner) login and password I see the tables in the list. What kind of rules in MS SQL I should give to my new, special user for SAS connection? I need to mention that when I put the db_owner role it also not working correctly. Any ideas?