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 Kerberos authentication

 

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";