integrated_server_name option

Specifies the name of the Domain Controller server used for looking up Windows user group membership for integrated user authentication (logins).

Allowed values

String

Default

Empty string

Scope

	PUBLIC role	For current user	For other users
Allowed to set permanently?	Yes, with SET ANY SECURITY OPTION	No	No
Allowed to set temporarily?	Yes, with SET ANY SECURITY OPTION	No	No

Remarks

This option allows a user with SET ANY SECURITY OPTION system privilege to specify the name of the Domain Controller server that is used to look up group membership when using Windows user groups for Integrated logins. By default, the computer that the database server is running on is used for verifying group membership.

Example

The following example specifies that group membership is verified on the computer server-1.

SET OPTION PUBLIC.integrated_server_name = '\\\\server-1';