in oracle :

$1-$Create a user user$1$ with password $1234567890$ containing a table t$1$

$2-$Create a user user$2$ and allow him to insert data into t$1$

$3-$Change password of user$2.$

$4-$Can you drop user$2$ without cascade option