There is no inheritence in our case.
As a short-time solution we have achieved a GRANT to an UPDATE (on categories). I try to provide an example project to solve it for the long-time but it takes a little bit time.
Search found 2 matches
- Thu 04 Aug 2011 06:20
- Forum: dotConnect for Oracle
- Topic: Wrong UPDATE-Statement on unauthorized table prevents saving
- Replies: 4
- Views: 1664
- Tue 02 Aug 2011 09:12
- Forum: dotConnect for Oracle
- Topic: Wrong UPDATE-Statement on unauthorized table prevents saving
- Replies: 4
- Views: 1664
Wrong UPDATE-Statement on unauthorized table prevents saving
Dear Devart Team,
we have a case where we get an exception 'ORA-01031: insufficient privileges' in the SaveChanges-Method on saving an object.
dbMonitor shows me that EntityFramework sends a statement (example recreated), which causes the exception:
UPDATE categories SET id = id WHERE concurrencytime = :p0
The column 'concurrencytime' has the property 'Concurrency Mode = Fixed' and is of the type DateTime.
I have got a main table (e.g. products) which has a reference to a foreign table (e.g. categories). In our case, the foreign table is part of a foreign scheme in Oracle where we have only grants to SELECT and not to UPDATE. This makes sense, because we don't want to change categories.
This statement has no practical effect, because the id will be updated to the value of the database which is already in the row. This error is not really relevant if I have grants to do everything, but in my case with restricted grants I can't go on.
We're using .NET 4.0 with Self-Tracking Entities and Devart dotConnect 6.30.165.
Can you please reproduce this case and provide a patch?
we have a case where we get an exception 'ORA-01031: insufficient privileges' in the SaveChanges-Method on saving an object.
dbMonitor shows me that EntityFramework sends a statement (example recreated), which causes the exception:
UPDATE categories SET id = id WHERE concurrencytime = :p0
The column 'concurrencytime' has the property 'Concurrency Mode = Fixed' and is of the type DateTime.
I have got a main table (e.g. products) which has a reference to a foreign table (e.g. categories). In our case, the foreign table is part of a foreign scheme in Oracle where we have only grants to SELECT and not to UPDATE. This makes sense, because we don't want to change categories.
This statement has no practical effect, because the id will be updated to the value of the database which is already in the row. This error is not really relevant if I have grants to do everything, but in my case with restricted grants I can't go on.
We're using .NET 4.0 with Self-Tracking Entities and Devart dotConnect 6.30.165.
Can you please reproduce this case and provide a patch?