Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
icw
Constraint Violating Yak Guru
378 Posts |
 Posted - 2009-09-18 : 06:02:34
|
| I have a SQL 2000 database called DB1I have a user called user1In user1's properties they have a tick in dbowner and public for the DB1 database.User1 accesses DB1 through an ODBC connection.Whenever someone using the programme does any edits (through the programme) it changes ownership on some of the tables to DB1.User1.Tablename instead of DB1.dbo.Tablename.So I end up with half the tables owned by User1 and half of them owned by DBO.This messes up reports and some stuff in the app.I do keep going baqck in and using the SP_Changeobjectowner to change them back to be owned by dbo.But i'm sure there must be another way so that the ownership doesn't change |
|
|
|
|
|
Table owner question