skip to main content
Connection property descriptions : SysLoginRole
  

Try DataDirect Drivers Now

SysLoginRole

Purpose

Specifies whether the user is logged on the database with the Oracle system privilege SYSDBA or the Oracle system privilege SYSOPER. For example, you may want the user to be granted the SYSDBA privilege to allow the user to create or drop a database.
Refer to your Oracle documentation for information about which operations are authorized for the SYSDBA and SYSOPER system privileges.

Valid values

sysdba|sysoper

Behavior

If set to sysdba, the user is logged on the database with the Oracle system privilege SYSDBA. The user must be granted SYSDBA system privileges before the connection is attempted by the driver. If not, the driver throws an exception and the connection attempt fails.
If set to sysoper, the user is logged on the database with the Oracle system privilege SYSOPER. The user must be granted SYSOPER system privileges before the connection is attempted by the driver. If not, the driver throws an exception and the connection attempt fails.
If this property is set to an empty string or is unspecified, the user is logged in without SYSDBA or SYSOPER privileges.

Data source method

setSysLoginRole

Default

empty string

Data type

String