Devart Forums

We have a problem where we cannot see columns of views/tables that are granted from another user.

Tables/views are in schema main_schema. We are trying to access them from user user_schema (all views/tables are granted with select privilege).

Connected to DB, created table TBL with one column named columnA.
Created an editionable view on the table (Edition based redefinition is enabled in our schemas).
Granted the view to user_schema (the user we are connecting with).
Checked if we can reach the view with a query - all is good.

create table tbl(columnA number);
create editionable view tbl_v as select columnA from tbl;
grant select on tbl_v to user_schema;
select * from main_schema.tbl_v;

Oracle version used: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

We are using Entity Developer with Devart.dotConnect for Oracle in asp.net mvc application:
Devart version 8.5.535

We connect with Entity Developer to Oracle DB as user_schema user and try to "Update Model From Database..."

We can select view tbl_v from the list of main_schema objects
TBL_V (Added)

Then we add this view to Model.
But storage editor does not see any columns in this object

We cannot reproduce the issue with the newest (9.5.381) build of dotConnect for Oracle. Please upgrade.

If this doesn't help, specify:
1) are you using a standalone Entity Developer or the one embedded in Visual Studio (VS version?)?
2) is your connection OCI (via Oracle Client) or Direct?
3) set primary key for columnA in TBL (then redo: create a view and grant select). Does this make any difference?

We are using:
1) Embedded entity developer with Visual Studio 2013 Professional;
2) OCI mode (Oracle client 11.1 version);
3) primary key does not help in our situation.

We are investigating your case.

We still cannot reproduce the issue.

1. Upgrade to the newest (9.5.399) build of dotConnect for Oracle.
2. Please try connecting in the Direct Mode. Does this make any difference?