DB object ownership problem.
Hi
(Please refer to attached screen shot)
I log into a SQL Server 2005 database using account admin_cbp_test and create a simple table, the table then has admin_cbp_test ownership, but I want the table objects always to have dbo ownership. How do I achieve that? Can I only do this with an sa account or can I add the user to a particular to achieve same result?
Thanks.
Image1.png
(Please refer to attached screen shot)
I log into a SQL Server 2005 database using account admin_cbp_test and create a simple table, the table then has admin_cbp_test ownership, but I want the table objects always to have dbo ownership. How do I achieve that? Can I only do this with an sa account or can I add the user to a particular to achieve same result?
Thanks.
Image1.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER