GRANT INTEGRATED LOGIN Statement

Grants INTEGRATED LOGIN privileges to a user.

Creates an explicit integrated login mapping between one or more Windows user profiles and an existing database user ID, allow a user who successfully log in to their local machine to connect to a database without having to provide a user ID or password.

Syntax

GRANT INTEGRATED LOGIN
  TO user_profile_name [, …] 
  AS USER userID [,...]

Parameters

userID – must be the name of an existing user or role that has a login password. Separate multiple userIDs with commas.

Standards

SQL – other syntaxes are vendor extensions to ISO/ANSI SQL grammar.
Sybase – the security model is different in Adaptive Server Enterprise and SAP Sybase IQ, so other syntaxes differ.

Permissions

Requires the MANAGE ANY USER system privilege.