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.