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 (Sybase Central)

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 and either the SELECT ANY TABLE system privilege or the SELECT privilege on the SYSLOGINMAP system view.

If you need to change the login mode, you must also have the SET ANY SECURITY OPTION 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.

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.

 Task
  1. Use the SQL Anywhere 16 plug-in to connect to the database.

  2. In the left pane, right-click Login Mappings and click New » Login Mapping.

  3. Select Integrated login mapping and click Next.

  4. In the Which Windows user will be connecting to the database field, type the name of the user or group profile for whom the integrated login is to be created.

  5. In the Which database user do you want to associate with the Windows user list, select the database user ID this user maps to.

  6. Follow the remaining instructions in the Create Login Mapping Wizard.

Results

The integrated login is created.