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.

Prérequis

You must have the MANAGE ANY USER system privilege.

Contexte et remarques

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.

Task

Connect to the database.
Execute a GRANT INTEGRATED LOGIN TO statement.

Résultat

The integrated login is created.

Exemple

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;

Creating an integrated login (SQL)

Task

See also