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 Mike Lewis 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
Mar 12, 2003
678
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
Schedule and automate backups of SQL Express databases in SQL Server Express 1
Replies
5
Views
310
JoPaBC
JoPaBC
lavadan
  • Locked
  • Question
current max value of all int columns
Replies
1
Views
98
fredericofonseca
fredericofonseca
Craig_DaviesB2
  • Locked
  • Question
Migration of SQL 2008 R2 Standard to SQL 2012 Standard - @flags parameter not valid SSIS
Replies
1
Views
99
simian336
simian336
TheBugSlayer
  • Locked
  • Question
Backu and restore of multiple filegroups
Replies
2
Views
87
TheBugSlayer
TheBugSlayer
dexterdg
  • Locked
  • Question
SQL SERVER: Query to get the last instance of an ID but return the first instance of that ID
Replies
2
Views
104
dexterdg
dexterdg

Part and Inventory Search

Sponsor

Back
Top