• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 382
  • Last Modified:

object 'LC_tbl', database 'LC', owner 'dbo'

Expert,

we created object LC_tbl table in DB LC by dbo owner and used user is 'domain\aa' with System admin permission created this object. I changed domain\aa system admin permission to read-only, it caused the object select table LC_tbl failed, can I change this object to sa role? b/c  domain\aa is windows login, everyone knows pwd and userid. I want to be security, so what level user login I should change to for this LC_tbl object.  
0
yrcdba7
Asked:
yrcdba7
  • 4
  • 3
1 Solution
 
RiteshShahCommented:
use this


EXEC sp_changeobjectowner 'LC_tbl', 'sa'
0
 
yrcdba7Author Commented:
expert,

how to check each objects with which onwer? we have hundreds objects create by user domain\aa, we are going to take this user away but we don't know which objects created by this users. can you tell the command?
thanks,
0
 
yrcdba7Author Commented:

expert,

I tried to change objects owner name to dbo, it gave me error like:

Cannot change owner of object 'LC_tbl" or one of its child objects because the new owner 'dbo' already has an object with the same name.

I look at the table owner is dbo.  but when I change domain\aa system admin
permission, why this object can not do select.

can you help?
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
yrcdba7Author Commented:

expert,
when I tried to run this:
EXEC sp_changeobjectowner 'LC_tbl', 'sa'


Server: Msg 15410, Level 11, State 1, Procedure sp_changeobjectowner, Line 55
User or role 'sa' does not exist in this database.

so what onwer I change to this tbl can do select? I can I see why domain\aa permission (system admin) changed, the object LC_tbl can not select?
0
 
RiteshShahCommented:
well, I can guess that either SA user doesn't exist or don't have permission to the database you are using. first of all find out what principal and its member available in your database, you can find it the way from my small article at:

http://www.sqlhub.com/2009/05/find-database-principal-and-its-member.html

As soon as you done with finding what user you have, you can use any of the user from that list, if SA is not there, you can't use it there.

0
 
yrcdba7Author Commented:

Expert,

I looked at your link, it looks like you used SQL 2k5, our DB still use sql 2k. do you have SQL 2k one?
0
 
RiteshShahCommented:
well in that case you can login to your enterprise manager, right click on the user and check its permission, I don't have SQL2K otherwise, I would have given you proper steps.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now