I have a problem where I have a ODBC connection to a MS SQL server. When I connect with my user name that have read access to some tabels and views. Some of the views have kolumns from tabels that Im not allowed to see, but its ok if its in the view. But Im not getting that kolumn from the tabel that Im not allowed to see. Is there no other solution then widen my access?
The second problem is that in some tabels Im not even getting all the kolumn, even if Im allowed to see it. We think its a problem with costum definition for those kolumns in MS SQL server. Have anny one else come across this and is there a solution?