Forum Stats

  • 3,874,239 Users
  • 2,266,700 Discussions
  • 7,911,777 Comments

Discussions

SQLcl, 21.3 (latest), Bug, Loading into/via a view no longer possible

andreml
andreml Member Posts: 127 Silver Badge

Hi there,

as requested by Jeff, now this message also here in the forum:

We have a new problem in 21.3 (latest) Loading into a view (Actual table is in a different schema, grants assigned to "loading schema".) is no longer possible.

So far this was OK and should be possible again. I guess you have restricted a query in your code to user_tables, but this is not OK; the views have to be considered as well - like before 21.3.

If you need more Info, please let me know.

Thank you!

Hint: Reported for the first time: 28. Okt. 2021, 11:53 to Garry and Jeff via Twitter.

Answers