Ruby On Rails et Oracle #2 : que dit le driver oci quand un utilisateur A n'a pas les droits Oracle sur une table d'un schéma B?
Par Renaud Gaudin le dimanche 20 mai 2007, 23:58 - RoR - Lien permanent
C:\apc_demo\InstantRails-1.4-win\InstantRails\rails_apps>ruby -r oci8 -e "OCI8.new('roor', 'roor', 'xe').exec('SELECT * FROM hr.jobs ORDER BY 1') do |r|puts r.join(' | '); end"
stmt.c:528:in oci8lib.so: ORA-00942: Table ou vue inexistante (OCIError)
from C:/apc_demo/InstantRails-1.4-win/InstantRails/ruby/lib/ruby/site_ru
by/1.8/oci8.rb:696:in `exec'
from C:/apc_demo/InstantRails-1.4-win/InstantRails/ruby/lib/ruby/site_ru
by/1.8/oci8.rb:141:in `do_ocicall'
from C:/apc_demo/InstantRails-1.4-win/InstantRails/ruby/lib/ruby/site_ru
by/1.8/oci8.rb:696:in `exec'
from C:/apc_demo/InstantRails-1.4-win/InstantRails/ruby/lib/ruby/site_ru
by/1.8/oci8.rb:236:in `exec'
from -e:1