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 |
|
sunnyjassal
Starting Member
28 Posts |
 Posted - 2004-09-15 : 10:23:05
|
| Hello,I have a user for a particular database. He is the owner for that database. He goes ahead and creates objects onto that DB, but when he does that he becomes the owner of the object also (his name appears as the owner). Basically, this causes problems because other users cant modify that object and problems start to arise from the web application.What I want to do is basically whenever this user creates an object I want the owner to be dbo. Is there a solution to this rather than manually going ahead and changing each object this user creates?Is there a role I can set to this person to accomplish this task? Note: There are other DB's on the server that this user should not get access to. This user should only be able to do whatever within his DB.Thank you for your help in advance.Sunny Jassal |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-09-15 : 10:37:54
|
| Ask him to script the objects with dbo.objname?? |
 |
|
|
sunnyjassal
Starting Member
28 Posts |
Posted - 2004-09-15 : 10:47:48
|
Thanks that does make sense.There should be no permission problem with that right?If he is the owner of the DB he should be able to do such correct?quote:
Originally posted by RickD
Ask him to script the objects with dbo.objname??
|
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-15 : 20:04:34
|
| Is he using Enterprise Manager by any change to create the stored procedures? (Please tell me it ain't so)MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Ownership of objects