Operating Condition
Syntax: SET WINAUTH ON/OFF
Default: OFF
SET WINAUTH controls if R:BASE will automatically authenticate database connections through Integrated Windows Authentication (IWA) with Windows Active Directory. When WINAUTH is set ON, the security features of the Windows clients and servers allows access to an R:BASE database when the Windows user name and password matches a defined R:BASE database user name and password. The current Windows user information on the client computer is supplied to R:BASE and does not prompt user for additional user name and password.
In order to use this feature, R:BASE database administrators must create an owner and user privileges for the database files to take full advantage of IWA support.
In addition to creating the database user privileges, the operating condition WINAUTH must be set to ON when prior to users connecting to the database. WINAUTH can be set within the R:BASE configuration file, or defined within an application startup file.
Requirements:
•WINAUTH must be set ON before connecting to the database.
•Database must contain an owner and user privileges that match Windows network accounts.
Notes:
•R:BASE will accept user names that contain spaces.
•Passwords are case-sensitive.
•If the authentication exchange initially fails to identify the user, R:BASE will prompt the user for a user name and password.
•A new CVAL Function (CVAL('WINAUTH')) has been established to check if WINAUTH is on.
•When an R:BASE user successfully connects to the database via IWA, the current R:BASE USER identifier is set to the current Windows user name.
