December 24, 2008 at 9:41 pm
i migrated dbs from 2000 - 2005. I see that one of the dbs the user is 'dbo' and login is 'domainame'...now when i try to give only read/write permissions to 'domainame' it gves error that i cant give read/write..i was going through this forum and found this link:
http://www.sqlservercentral.com/Forums/Topic405295-146-1.aspx?Highlight=dbo
But i am still confused..i cant make any of the logins as dbowner..i need to the user from 'dbo' to 'loginame' as user mapped to 'loginame'..like right now user is 'dbo' for 'sqlserver\john'..i need to make the user as 'sqlserver\john'..i don't know how this user became 'dbo'...i cant give any dbowner permissions to other logins..please suggest me..thanks in advance and happy holidays..
December 26, 2008 at 6:48 am
You need to associate dbo with another user (SA is always a good candidate if you are using mixed auth)...
USE 'DBName';
EXEC sp_addalias 'sa', 'dbo'
You may need to droplogin on the existing user first but I don't know if it will allow you to have dbo dissociated from any login:
EXEC sp_dropalias 'OldDomain\OldUser'
Hope this helps!
AndyG
AndyG
December 26, 2008 at 7:58 am
Andy has the right idea, but why can you not just grant db_owner to a user as a role. This is the same as dbo.
December 26, 2008 at 8:06 am
It sounded like the problem was that User1 is currently mapped to dbo and the DBA did not wish it to be...?
AndyG
AndyG
December 26, 2008 at 8:13 am
thank you for replying me..now...i tried doing what u said but gave me some error..like for one of the db im the db owner domainame\xyz...i went to the db and again ran sp_changedbowner to domainame\xyz...and then it worked fine..i could change the db roles for the user...im only confused that even though i was the dbowner i couldn't change..but when i ran changedbwonwer again to myname..it worked..thx again..
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply