Page 1 of 1

DBA Privilege parameter

Posted: Fri 02 Aug 2013 13:56
by malsergey
Hi,
Does dotConnect for Oracle supports "DBA Privilege" attribute for connection string?
I can't found parameter in connection builder for "DBA Privilege" attribute. Also when I trying to add this parameter to connection string i got error about wrong parameter.

Thanks,
Sergey

Re: DBA Privilege parameter

Posted: Mon 05 Aug 2013 13:44
by Pinturiccio
Yes, dotConnect for Oracle supports connecting with DBA privileges. OracleConnection class has the ConnectMode property, allowing you to connect as SYSDBA or SYSOPER. For more information please refer to http://www.devart.com/dotconnect/oracle ... tMode.html

You may also specify the value of this property in the connection string. See example below:

Code: Select all

OracleConnecion conn = new OracleConnection("Data source=xxx; user id=xxx; password=xxx; Connect Mode=sysdba;");