receiving "insufficient privileges on underlying objects of the view: EXPLAIN PLAN FOR"

[Liam Morley]

I've been using the 1.3.x gem of activerecord-oracle_enhanced-adapter
with Rails 2.3 pretty successfully (thank you!), but I'm investigating
upgrading to Rails 3.2 right now. My Gemfile is pulling directly from
the github.com/rsim/oracle-enhanced.git master branch, version ~1.4.0.

I'm trying a find_by_sql command that worked fine in Rails 2.3, but
now is producing an error:

OCIError: ORA-01039: insufficient privileges on underlying objects of
the view: EXPLAIN PLAN FOR

This is an external database, so I can't change the privileges. Is
there a way that the 1.4.x gem can recover from this and do the same
thing that 1.3 would do?

[Yasuo Honda]

Hi,

>>
config.active_record.auto_explain_threshold_in_seconds = nil
<<

Then Rails will not automatically executes explain command.

--
Yasuo Honda

> --
> You received this message because you are subscribed to the Google Groups "Oracle enhanced adapter for ActiveRecord" group.
> To post to this group, send email to oracle-...@googlegroups.com.
> To unsubscribe from this group, send email to oracle-enhanc...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/oracle-enhanced?hl=en.
>

[Liam Morley]

Ah, so this is an artifact of upgrading to Rails 3.2 - sorry about
that. I commented out the 'auto_explain' line in development.rb and
everything is much better. Thanks!

Liam