In this blog post, you’ll learn more about the Sybase Error User owns tables in use and the reason for receiving this error
Sybase SQL Error Message
User owns tables in use
Reason for this Error
You attempted to REVOKE CONNECT from a user that owns a table being used by other active users of the database.