Re: Question about dropping owner's permissions...
From: Jason Barnett (jbarnett74_at_hotmail.com)
Date: 10/29/03
- Next message: Kalen Delaney: "Re: Question about dropping owner's permissions..."
- Previous message: Sue Hoegemeier: "Re: sql permissions and adp"
- In reply to: Kalen Delaney: "Re: Question about dropping owner's permissions..."
- Next in thread: Kalen Delaney: "Re: Question about dropping owner's permissions..."
- Reply: Kalen Delaney: "Re: Question about dropping owner's permissions..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 29 Oct 2003 11:06:04 -0600
I apologize. As it turns out, that is precisely what I wanted to do.
For some reason it didn't seem to be working; when I assigned the user to
db_owner group, the objects they created were owned by the user -- not dbo.
I must have had a conflicting setting somewhere in the process.
Thanks for your help.
---Jason
"Kalen Delaney" <replies@public_newsgroups.com> wrote in message
news:%2380fTtjnDHA.2424@TK2MSFTNGP10.phx.gbl...
> Hi Jason
>
> I'm not completely sure I understand the questions. But, why don't you
have
> all objects owned by the dbo user. Since there is always a dbo, you
wouldn't
> have to switch names when someone leaves. A user in the db_owner role can
> create objects owned by the dbo user, and that is what I always recommend.
>
> --
> HTH
> ----------------
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
>
> "Jason Barnett" <jbarnett74@hotmail.com> wrote in message
> news:#MHzQKjnDHA.2000@TK2MSFTNGP12.phx.gbl...
> > I'm using SQL Server 7.0 and my question pertains to securing my
test
> > machine so that developers can create objects within databases, but not
> > create databases themselves. I have done this by adding them to the
> > db_owner role for each database (about 24 of them). This would work
fine
> if
> > I could easily switch ownership of all objects in the database at the
time
> > that the developer leaves the company.
> > Can anyone help me reach my end goal: Allowing developers to create
> > objects but not databases, and easily switch the owner?
> >
> >
>
>
- Next message: Kalen Delaney: "Re: Question about dropping owner's permissions..."
- Previous message: Sue Hoegemeier: "Re: sql permissions and adp"
- In reply to: Kalen Delaney: "Re: Question about dropping owner's permissions..."
- Next in thread: Kalen Delaney: "Re: Question about dropping owner's permissions..."
- Reply: Kalen Delaney: "Re: Question about dropping owner's permissions..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
