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.

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.

You can use either the Create Login Mapping Wizard or a SQL statement to create an integrated login mapping.

To map an integrated login (Sybase Central)

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

1. Open Sybase Central.

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

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

4. Click Next.

5. 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.

6. In the Which Database User Do You Want To Associate With The Windows User list, select the database user ID this user maps to

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

To map an integrated login (SQL)

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

2. Execute a GRANT INTEGRATED LOGIN TO statement.

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;

See GRANT statement.

The following SQL statement allows Windows users who are members of the Windows NT 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 Creating integrated logins for Windows user groups.