February 11, 2011 at 11:20 am
Hi,
Iam new to dba. If I open Enterprise Manager 2000 (no login) and create a database and
tables inside. Owner of tables is always dbo. I have a different user I want to be an owner of these tables.
What should I do? I assume I need to login into Enterprise Manager 8.0 as that user not dbo. But I can't find how to login into Enterprise Manager. It just opens no login offered.
____________________________________________________________________
Going in one more round when you don't think you can - that's what makes all the difference in your life --Rocky Balboa
Believe you can and you're halfway there. --Theodore Roosevelt
February 14, 2011 at 6:17 am
vk24/7 (2/11/2011)
Hi,Iam new to dba. If I open Enterprise Manager 2000 (no login) and create a database and
tables inside. Owner of tables is always dbo. I have a different user I want to be an owner of these tables.
What should I do? I assume I need to login into Enterprise Manager 8.0 as that user not dbo. But I can't find how to login into Enterprise Manager. It just opens no login offered.
Anybody got an answer for this? any suggestion??
____________________________________________________________________
Going in one more round when you don't think you can - that's what makes all the difference in your life --Rocky Balboa
Believe you can and you're halfway there. --Theodore Roosevelt
February 14, 2011 at 7:02 am
Hi,
You could check out how sp_changedbowner works. I mean sp_changeobjectowner 🙂
__________________________
Allzu viel ist ungesund...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply