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 |
|
mbevon
Starting Member
41 Posts |
 Posted - 2002-08-21 : 14:29:29
|
| What could be wrong?Me and my colleague have the same permission to a database.Surprisingly when she creates a file, the ownership is set to DBO, when i do likewise the ownership is 'Stats\marlon'.why is this happenning?thanks |
|
|
Onamuji
Aged Yak Warrior
504 Posts |
Posted - 2002-08-21 : 14:44:11
|
| she is setup at the dbo of that database... i think... check to see if you are both have the db_owner permission set on your user access to the database... |
 |
|
|
mbevon
Starting Member
41 Posts |
Posted - 2002-08-21 : 15:10:06
|
| How could i check to see if she's the db-owner? |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-08-21 : 15:23:40
|
| One simple way is to open Enterprise Manager, open this database and look at Users. Who is listed as dbo there?<rant>This has tripped me up more than one time... Assigning somebody to the db_owner database role DOES NOT mean that when they create objects the object will be owned by dbo. There's probably a good MS reason for this, but in my world it sucks!I know, I know... they should specify dbo as the owner in the CREATE statement... I'm working on them. Education can be a slow process. Especially when the first question is "What's Query Analyzer?"</rant> |
|
|
|
|
|
|
Permissions(this is weird)