To work it properly :privilege option must be :SYSDBA or :SYSOPER
or u will get error ArgumentError: invalid privilege name sysdba
(expect :SYSDBA or :SYSOPER)
Here my working example: DB =
Sequel.connect('oracle://sys:[email protected]:1521/xe', :privilege =>
:SYSDBA )
> On Fri, Oct 9, 2009 at 5:24 PM, Jeremy Evans <[email protected]> wrote:
>> On Oct 9, 6:32 am, loki <[email protected]> wrote:
>>> Trying to connect but have this error:
>>> DB = Sequel.connect('oracle://sys:[email protected]:1521/xe')
>>> How to connect as SYSDBA using Sequel?
>>
>> This was discussed on the IRC channel, and it turned out the following
>> worked:
>>
>> DB = Sequel.connect('oracle://sys:[email protected]:1521/
>> xe', :privilege=>'sysdba')
>> DB = Sequel.oracle(:host => '127.0.0.1', :port => 1521, :user =>
>> 'sys', :password => 'oracle', :database => 'xe', :privilege=>'sysdba')
>>
>> I'm guessing the following will also work:
>>
>> DB = Sequel.connect('oracle://sys:[email protected]:1521/xe?
>> privilege=sysdba')
>>
>> Jeremy
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
