Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
PanzerAttack
Yak Posting Veteran
71 Posts |
 Posted - 2011-07-11 : 10:13:57
|
| I was looking at the security folder - users and can see I'm against something called dboWhen I look at the Script:USE [DS Reporting Database]GO/****** Object: User [dbo] Script Date: 07/11/2011 15:09:55 ******/GOCREATE USER [dbo] FOR LOGIN [XXXXXX\BOB] WITH DEFAULT_SCHEMA=[dbo]I want to edit this to change the roles and change the username but when I try I get the message:The login alrady has and account under a different user nameHow do I edit this dbo user? |
|
|
PanzerAttack
Yak Posting Veteran
71 Posts |
Posted - 2011-07-12 : 07:04:43
|
| Any help on this one? |
 |
|
|
sqldataguy
Starting Member
12 Posts |
Posted - 2011-07-12 : 10:01:05
|
| drop userand rebuild in Mgmt Console where you can specify the role, databases and default schema.- or -modify your command to pick a different default schema. (I think you could even leave out the 'with default schema....') |
|
|
|
|
|
|
The login already has an account under a different