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"