Re: dbo role and modify filesize of database

From: Mickey Red (mred_at_red.com)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 15:01:49 -0600

Hi Dan

Thanks for your reply.

It's not possible the remove the user from the dbo_owner role because
it's a app developer and needs dbo rights for creating tables and other
objects in a database. The role datawriter is not enough.

I'm still searching for alternatives, because i think all what has to do
with space-management on the server is the dba's job. Perheaps you or
someone other knows an other alternative.

Thanks

Mickey

"Dan Guzman" <danguzman@nospam-earthlink.net> wrote in
news:#ekYQVH$DHA.2432@TK2MSFTNGP11.phx.gbl:

>> If I create a database and give to the database user
>> dbo role membership he is able to change size of datafiles
>> mdf and ldf. How can i suppress that so that this is no longer
>> possible?
>
> Don't add the user to the db_owner role :-)
>
> Membership of db_owner, sysadmin, etc. have powerful rights that
> (hopefully) aren't needed for routine application functionality.
> Normally, one can create user-defined rules with appropriate object
> permissions and control access via role membership.
>
> What application requirement do you have that currently necessitates
> db_owner role membership? Perhaps we can come up with an alternative
> solution.
>