What happens when a database user is dropped?
All objects (tables, views, etc.) are dropped and the cleared storage space is released to free space management.
