Resetting User Default DB

Database
Enthusiast

Resetting User Default DB

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:

MODIFY USER user_name AS DEFAULT DATABASE=null;

The above syntax is failing.

Do you know how to revert back to NULL as default DB?

Tags (1)
1 REPLY
Senior Apprentice

Re: Resetting User Default DB

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;