GRANT INTEGRATED LOGIN Statement

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

Quick Links:

Go to Parameters

Go to Standards

Go to Permissions

Syntax

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

Parameters

(back to top)

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

Standards

(back to top)

SQL–other syntaxes are vendor extensions to ISO/ANSI SQL grammar.
SAP Database products–the security model is different in SAP ASE and SAP IQ, so other syntaxes differ.

Permissions

(back to top)

Requires the MANAGE ANY USER system privilege.