Revoking Kerberos login permission

You can remove a Kerberos login mapping using either Sybase Central or a SQL statement.

To revoke a Kerberos login mapping (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 a Kerberos login mapping (SQL)

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

  2. Execute a REVOKE KERBEROS LOGIN FROM statement.

    See REVOKE statement.

Example

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

REVOKE KERBEROS LOGIN
FROM "pchin@MYREALM.COM";
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0