Creating an Integrated Login in SQL

User profiles can only be mapped to an existing database user ID. When that database user ID is removed from the database, all integrated login mappings based on that database user ID are automatically removed.

The following SQL statement allows Windows users fran_whitney and matthew_cobb to log in to the database as the user DBA, without having to know or provide the DBA user ID or password.

GRANT INTEGRATED LOGIN 
TO fran_whitney, matthew_cobb 
AS USER DBA

For more information, see Reference: Statements and Options > SQL Statements > GRANT Statement.