Query to find list of users not schemas

 

select username from dba_users minus select distinct owner from dba_objects ;