Error Description:

Msg 17545, Level 16, State 1:
Server 'SYB_ASE', Procedure 'sp_dropuser', Line 267:
You cannot drop user because user 'testuser' owns objects in database.

Resolution:

Step1: First find out uid of user

1> select uid from sysusers where … Read the rest