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