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 and
SAP Sybase IQ, so other syntaxes
differ.
Permissions
(back to top)
Requires the MANAGE ANY USER system privilege.