All Forums Database
Kishore_1 208 posts Joined 03/10
15 Feb 2015
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?

 

dnoeth 4628 posts Joined 11/04
16 Feb 2015

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;

 

Dieter

You must sign in to leave a comment.