Re: Question about dropping owner's permissions...

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 10/29/03


Date: Wed, 29 Oct 2003 08:40:07 -0800

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?
>
>


Relevant Pages

  • Re: Question about dropping owners permissions...
    ... > create objects owned by the dbo user, and that is what I always recommend. ... >> machine so that developers can create objects within databases, ... >> create databases themselves. ... >> I could easily switch ownership of all objects in the database at the ...
    (microsoft.public.sqlserver.security)
  • Question about dropping owners permissions...
    ... I'm using SQL Server 7.0 and my question pertains to securing my test ... create databases themselves. ... I could easily switch ownership of all objects in the database at the time ... Can anyone help me reach my end goal: Allowing developers to create ...
    (microsoft.public.sqlserver.security)
  • Re: Migrating away from MS-Access
    ... Most databases are crap, beginning with the original northwind sample ... Many developers and sa's use system databases as a support for their ... Many IT personnel have no background in programming yet feel fully ... Then I was told our totals weren't the spreadsheet's total which were ...
    (comp.databases.ms-access)
  • Re: Migrating away from MS-Access
    ... Most databases are crap, beginning with the original northwind sample ... Many developers and sa's use system databases as a support for their ... Many IT personnel have no background in programming yet feel fully ... Then I was told our totals weren't the spreadsheet's total which were ...
    (comp.databases.ms-access)
  • Re: MAINFRAME SHOP STANDARDS
    ... > databases) accessibility from non-COBOL was not one of ... When VSAM was released it quickly replaced ISAM because of its ... the efficiency of DBMS improved many thousands of times. ... developers makes them look for other ways. ...
    (comp.lang.cobol)