ORA-01031: insufficient privileges with Oracle view using Entity Framework
This has been resolved. Because I am working with existing Oracle database, I had to disable database initializer.
public VisualInspectionDbContext() : base("name=GisStageDbContext"){ Database.SetInitializer<VisualInspectionDbContext>(null);}Basically DART user is low privilege user and does not have any permissions to create database table. Each time DBContext object initializes - Entity Framework was trying to create Oracle table under user that does not have permissions. Anyway if you work with existing database - disable initializer, otherwise; each table will be recreated based on C# class definition. I hope this post will help other people.
Regards,
Serghei