f2s_ora_auth_mode

Applies to: Oracle Driver

Syntax

set_attribute f2s_ora_auth_mode of {DriverId} to {variable}
get_attribute f2s_ora_auth_mode of {DriverId} to {variable}

Parameter

Description

DriverId

The ID of the driver for which this applies. In most cases, you should use _f2s_ActiveDriverID.

variable

Integer value of either 0 (user logged in with their privileges) or 1 (user logged in with the roles assigned to sysdba user).

Description

This attribute is used to control what mode the user logs in as. When 0 is passed, the user will be logged in with the default privileges given to it. When 1 is passed, the user will be logged in with the roles assigned to the sysdba user, most likely full control over the database.

Setting this attribute must be done AFTER the driver is activated (f2s_activate_driver “f2s_or”) but BEFORE calling the login command (login server user password “f2s_or”). Getting this attribute can be done at any time.

Examples

get_attribute

integer iType
Get_Attribute f2s_ora_auth_mode of _f2s_ActiveDriverId to iType

set_attribute

f2s_activate_driver "f2s_or"
Set_Attribute f2s_ora_auth_mode of _f2s_ActiveDriverId to 1
Login "MyOracleServer:1521/MyDatabase" "MyUser" "MyPassword" "f2s_or"

Replaces

SET_AUTHENTICATION_MODE