database ownership issues

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » database ownership issues

database ownership issues

Rate Topic

Display Mode

Topic Options

Author

Message

sahmad43

Posted Monday, November 05, 2012 8:17 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, November 29, 2012 1:56 PM
Points: 34, Visits: 56

I have my databases user and default schema set for 'dbo'
but if i import a new database , and look at the security its user and default schema fields are empty and if i try to assign sa as db_owner of this database i get an error.
how can i make this database after import user=dbo and 'default schema'=dbo
and have sa user teh dbowner of this database .. .like my all other databases ?

thanks

Post #1381105

Ratheesh.K.Nair

Posted Monday, November 05, 2012 9:23 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 7:51 AM
Points: 2,415, Visits: 3,373

What error you got??

Post #1381155

Lowell

Posted Monday, November 05, 2012 11:55 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 7:55 AM
Points: 11,607, Visits: 27,654

you can search fro more infor by searching "SQL SERVER CHANGE DATABASE OWNER;

the BOL Links are here for the explanation and the code:
Changing the Database Owner
ALTER AUTHORIZATION (Transact-SQL)

and a basic command example:

--SQL2005 and before:
--assumes the current database is the one to change
EXEC sp_changedbowner 'sa'
 --2008 and after
ALTER AUTHORIZATION
   ON database::SandBox
   TO sa

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1381228

« Prev Topic | Next Topic »

Permissions