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.
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.
Connect to the database.
Execute a GRANT INTEGRATED LOGIN TO statement.
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;
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|