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
Update model from Oracle database does not see columns
-
- Posts: 7
- Joined: Fri 05 Mar 2010 11:18
- Location: Vilnius
Re: Update model from Oracle database does not see columns
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?
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?
-
- Posts: 7
- Joined: Fri 05 Mar 2010 11:18
- Location: Vilnius
Re: Update model from Oracle database does not see columns
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.
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.
Re: Update model from Oracle database does not see columns
We are investigating your case.
Re: Update model from Oracle database does not see columns
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?
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?