Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » Database connections » Windows integrated logins

 

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 the MANAGE ANY USER system privilege.

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.

 Task
  1. Connect to the database.

  2. Execute a GRANT INTEGRATED LOGIN TO statement.

Results

The integrated login is created.

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