Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Database Owner
- Thread starter mrliam69
- Start date
Database owner and table owner are two different things.
Do you have the SA or Sysadmin account information? If so, just log in as that and you should have all the rights you need to do whatever you want.
If you're actually trying to change the owner of a user owned database/table/object, you can use the sp_changedbowner or sp_changeobjectowner system stored procedures.
Caveats are as follows:
To use sp_changeDBOwner, youneed to be Sysadmin or the current owner of the db.
To use sp_ChangeObjectOwner you need to be Sysadmin or be assigned to the DBO, db_ddladmin or db_securityAdmin roles.
Hope that helps.
Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???
Do you have the SA or Sysadmin account information? If so, just log in as that and you should have all the rights you need to do whatever you want.
If you're actually trying to change the owner of a user owned database/table/object, you can use the sp_changedbowner or sp_changeobjectowner system stored procedures.
Caveats are as follows:
To use sp_changeDBOwner, youneed to be Sysadmin or the current owner of the db.
To use sp_ChangeObjectOwner you need to be Sysadmin or be assigned to the DBO, db_ddladmin or db_securityAdmin roles.
Hope that helps.
Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question