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.
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 Sybase Database product–the security model is
different in Adaptive Server Enterprise and
SAP Sybase IQ, so other syntaxes
differ.
Permissions
(back to top)
Requires the MANAGE ANY USER system privilege.