Skip to main content
  • EN

I want to read some views in Microsoft SQL Server Database using a Database-Alias (not the Servername).

I tried to make a DB-Connection using Microsoft SQL Server (ADO), but it didn't work with the alias (it works with the Servername).
With a Microsoft SQL Server (JDBC)-DB-Connection, I can access the DB, using the DB-alias.
 
Then I wanted to read the views, using the Microsoft SQL Server Spatial (JDBC)-Reader:
I can access the database, but not the views. (In a database-application like DBeaver it works fine) 

TheDB- user account I use, is allowed to read the view, but not the underlying tables. 

Is FME not able to handle those permissions? 

 

FME is able to use SQL Server DB Aliases (we are using them ourselves), so not sure why that won’t work in your setup. I am not familiar enough with DB aliases to be able to say anything about that, except that it should work with a simple Microsoft SQL Server (ADO)  DB Connection.

 

As far as views and underlying tables go, if the views and the tables have different owners, then the users need permissions on the tables. If the views and the tables have the same owner, permission chaining allows for skipping the permissions on the tables. See here.

Reply


Community Stats

30,418
Posts
115,551
Replies
38,231
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.