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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Owner of Table

Status
Not open for further replies.
klewis10367

klewis10367

MIS
Joined
Mar 12, 2003
Messages
678
Location
US
I have a user who needs to create tables and or views in SQL 2000. I do not want to put them in the dbo group but I also do not want their Windows Account being the Owner of the table or view. Is there a way to make the owner dbo even though the user who created it does not have dbo rights?
 
Sort by date Sort by votes
You can change the objectowner after it is created.

look up sp_changeobjectowner in BOL (books on-line)

- Paul
- If at first you don't succeed, find out if the loser gets anything.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JoPaBC
  • Locked
  • Question Question
Schedule and automate backups of SQL Express databases in SQL Server Express
Replies
5
Views
1K
JoPaBC
JoPaBC
lavadan
  • Locked
  • Question Question
current max value of all int columns
Replies
1
Views
382
fredericofonseca
fredericofonseca
Craig_DaviesB2
  • Locked
  • Question Question
Migration of SQL 2008 R2 Standard to SQL 2012 Standard - @flags parameter not valid SSIS
Replies
1
Views
421
simian336
simian336
TheBugSlayer
  • Locked
  • Question Question
Backu and restore of multiple filegroups
Replies
2
Views
399
TheBugSlayer
TheBugSlayer
dexterdg
  • Locked
  • Question Question
SQL SERVER: Query to get the last instance of an ID but return the first instance of that ID
Replies
2
Views
346
dexterdg
dexterdg

Part and Inventory Search

Sponsor

Back
Top