ASA Database Administration Guide
  Connecting to a Database
    Using integrated logins
      Using integrated logins

Creating an integrated login

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 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 user ID.

Only users with DBA authority are able to create or remove an integrated login mapping.

An integrated login mapping is made either using a wizard in Sybase Central or a SQL statement.

To map an integrated login (Sybase Central)

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

2. Click the New Integrated Login button on the toolbar.

3. On the first page of the wizard, specify the name of the system (computer) user for whom the integrated login is to be created.

   Also, select the database user ID this user maps to. The wizard displays the available database users. You must select one of these. You cannot add a new database user ID.

4. Follow the remaining instructions in the wizard.

To map an integrated login (SQL)

1. Connect to a database with DBA authority.

2. Execute a GRANT INTEGRATED LOGIN TO statement.

Example 

The following SQL statement allows Windows NT 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

For more information, see GRANT statement.