A System Administrator can use sp_droplogin to deny a user access to Adaptive Server. The syntax is:
sp_droplogin loginame
You cannot use sp_droplogin to drop a user from any database on the server. Use sp_dropuser to drop the user from a database. You cannot drop a user from a database if that user owns any objects in the database. For more information, see “Dropping users”.
