Trolltech Home | Qt-interest Home | Recent Threads | All Threads | Author | Date
All threads index page 3

Qt-interest Archive, March 2002
how to connect to Oracle as sysdba


Message 1 in thread

Hello all,

Anyone know how to connect to Oracle as sysdba using QSqlDatabase. Any 
help will be appreciated!
Thanks in advance!

Bye,
Marian


Message 2 in thread

There is no user in an Oracle database called "sysdba", unless you have
explicitly created one. The master logins are sys and system which have
default passwords of "change_on_install" and "manager" by default.

--dan


On Thu, 7 Mar 2002, Popeanga Marian wrote:

> Hello all,
>
> Anyone know how to connect to Oracle as sysdba using QSqlDatabase. Any
> help will be appreciated!
> Thanks in advance!
>
> Bye,
> Marian
>
> --
> List archive and information: http://qt-interest.trolltech.com
>


Message 3 in thread

Dr. Dan P. Plunkett wrote:

>There is no user in an Oracle database called "sysdba", unless you have
>explicitly created one. The master logins are sys and system which have
>default passwords of "change_on_install" and "manager" by default.
>
>--dan
>
>
>On Thu, 7 Mar 2002, Popeanga Marian wrote:
>
>>Hello all,
>>
>>Anyone know how to connect to Oracle as sysdba using QSqlDatabase. Any
>>help will be appreciated!
>>Thanks in advance!
>>
>>Bye,
>>Marian
>>
>>--
>>List archive and information: http://qt-interest.trolltech.com
>>
>
>--
>List archive and information: http://qt-interest.trolltech.com
>
    Yes you have wright but when i say that, i mean that i want to be 
connected to the database through the password file of the database.
Even you get connected to the database as SYSTEM or SYS you can't make 
all the operations you want on the database (Ex startup, shutdown , etc 
...).
You should be able to connect like this from sql plus:
          connect internal    if you are on the same machine like the 
database or
          connect system/manager@database_at_distance as sysdba  
Now you can make any operations you want on the database.   So it is 
important to make this tipe of connection as sysdba or sysoper.

     How we can make that from QSqlDabase ?  Thanks in advance!

Marian