Use the DROP EXTERNLOGIN statement to remove external logins from the Sybase IQ system tables.
The following statement drops the external login for the local user fred created in the example above:
DROP EXTERNLOGIN fred TO ASEserver
For more information, see DROP EXTERNLOGIN statement in Sybase IQ Reference Manual.