I modified default db of a user whose default Db was null to a specific value.
Now I want to revert back the default DB to null:
Hmmm, there seems to be no syntax for this.
As NULL defaults to the user you might do
MODIFY USER user_name AS DEFAULT DATABASE=user_name;