Is it possible to change the login that is associated with dbo?
I inadvertantly ended up mapping the rw account to dbo by doing :
CREATE USER [dbo] FOR LOGIN [app_rw] WITH DEFAULT_SCHEMA=[dbo]
Is there any way to undo this such I get the equivalent of :
CREATE USER [dbo] WITH DEFAULT_SCHEMA=[dbo]
CREATE USER [app_rw] FOR LOGIN [app_rw] WITH DEFAULT_SCHEMA=[dbo]
I tried ALTER USER but all that allows for is to change the login name.