SAP Knowledge Base Article - Preview

2564630 - Unable to drop user usedb_user - SAP ASE


  • There is one user account named 'usedb_user' in each database's sysusers table, but there's no related entry in syslogins.
  • Under some auditing reports, this user would sometimes be caught as an orphan id which is supposed to be dropped, since there is no associated login to it.
  • ASE would report below error when dropping this user account:

1> sp_dropuser usedb_user

2> go

Msg 17543, Level 16, State 1:

Server 'xxx', Procedure 'sp_dropuser', Line 169:

You cannot drop the 'usedb_user'.

(return status = 1)



  • SAP Adaptive Server Enterprise (ASE) 15.7 ESD#2 and higher
  • SAP Adaptive Server Enterprise (ASE) 16.0 all versions


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0


usedb_user, granular permissions, orphan, syslogins, sysusers , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.