SQL Server Performance Forum – Threads Archive

sql security: urgent!

Hi I need to create the database whose owner is not "dbo"
Cannot figure it out . How do I accomplish it?

Create the database and assign an user as a database owner, the dbo user cannot be deleted and is always present in every database. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Well I do have one database that doesn’t have "DBO" as an owner of it.
To be more clear: Name LoginName databaseAccess
MyUser MyUser Permit This is the only user in that db – owner MyUser My problem is that I do not recall how I did it.
Could someone help?

SP_CHANGEDBOWNER – refer to books online for further information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>