Creating an integrated login (SQL)

You can use a Windows integrated login with SQL Anywhere to maintain a single user ID and password for operating system and network logins, as well as your SQL Anywhere database connections.

Prerequisites

You must have DBA authority to create or delete an integrated login mapping.

Context and remarks

A user or group profile does not have to exist for it to be mapped to a database user ID. More than one user profile can be mapped to the same database user ID.

 Map an integrated login (SQL)

  1. Connect to the database as a user with DBA authority.

  2. Execute a GRANT INTEGRATED LOGIN TO statement.

Results

The integrated login is created.

Next

None.

Example

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;

The following SQL statement allows Windows users who are members of the Windows group mywindowsusers 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 mywindowsusers
AS USER DBA;

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1