Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » Connecting to a database » Using integrated logins » Setting up integrated logins

 

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