A system security officer can use sp_droplogin to deny a user access to Adaptive Server. The syntax is:
sp_droplogin login_name
sp_droplogin fails if the user identified by login_name exists as a database user or alias in any database. Use sp_dropuser to drop the user from a database. See “Dropping users”.
