Revoking integrated login permission

You can remove an integrated login mapping using either Sybase Central or Interactive SQL.

To revoke an integrated login permission (Sybase Central)

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

  2. Open the Login Mappings folder.

  3. In the right pane, select the login mapping you want to remove, and then choose File » Delete.

To revoke an integrated login permission (SQL)

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

  2. Execute a REVOKE INTEGRATED LOGIN FROM statement.

Example

The following SQL statement removes integrated login permission from the Windows user pchin.

REVOKE INTEGRATED LOGIN
FROM pchin;

See REVOKE statement.

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0