SQL Anywhere® Server - Database Administration  > 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 DBA user.

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

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"

---