db_owner - Unauthorized Size increase

Hello There,
I have a simple questions.
How can i restrict the maximum size of the database for a db_owner?
ALTER DATABASE permissions default to members of the sysadmin and
dbcreator fixed server roles, and to members of the db_owner fixed
database roles. These permissions are not transferable.
They can do this:
This example creates a database and alters it to add a new 5-MB data
file.
USE master
ALTER DATABASE Test1
ADD FILE
(
NAME = Test1dat2,
FILENAME = 'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\t1dat2.ndf',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB
)
GO
What i want is to provide the db_owner but we need to restrict the
maxSize of the database.
Sincerely,
Yusbel GarciaIf somebody is db_owner, they can do whatever they like, within
the databases that they own.
Your best bet, which as always is the one involving the most work,
is to look at what functionality your users "must" have, in order for
them to perform their functions.
As always, if you leave something available for someone to use,
they'll eventually use it.
"Yusbel Garcia" <yusbel@.ISQsolutions.com> wrote in message
news:769e3cd4.0308121023.6b555837@.posting.google.com...
> Hello There,
> I have a simple questions.
> How can i restrict the maximum size of the database for a db_owner?
> ALTER DATABASE permissions default to members of the sysadmin and
> dbcreator fixed server roles, and to members of the db_owner fixed
> database roles. These permissions are not transferable.
> They can do this:
> This example creates a database and alters it to add a new 5-MB data
> file.
> USE master
> ALTER DATABASE Test1
> ADD FILE
> (
> NAME = Test1dat2,
> FILENAME = 'c:\Program Files\Microsoft SQL
> Server\MSSQL\Data\t1dat2.ndf',
> SIZE = 5MB,
> MAXSIZE = 100MB,
> FILEGROWTH = 5MB
> )
> GO
> What i want is to provide the db_owner but we need to restrict the
> maxSize of the database.
>
> Sincerely,
> Yusbel Garcia|||Thank for your answer, i believe that microsoft it should have a solutions
to revoke the alter database permission for a db_owner database exist some
hosting company that are providing the db_owner permission and they restrict
the maxSize of a database unles they lie, and i don't believe they use the
windows quota to restrict the maxSize Database.
Regards,
Yusbel Garcia
"Stressed" <k@.c.co.uk> wrote in message
news:eMV%23FuaYDHA.2448@.TK2MSFTNGP09.phx.gbl...
> If somebody is db_owner, they can do whatever they like, within
> the databases that they own.
> Your best bet, which as always is the one involving the most work,
> is to look at what functionality your users "must" have, in order for
> them to perform their functions.
> As always, if you leave something available for someone to use,
> they'll eventually use it.
>
> "Yusbel Garcia" <yusbel@.ISQsolutions.com> wrote in message
> news:769e3cd4.0308121023.6b555837@.posting.google.com...
> > Hello There,
> >
> > I have a simple questions.
> >
> > How can i restrict the maximum size of the database for a db_owner?
> >
> > ALTER DATABASE permissions default to members of the sysadmin and
> > dbcreator fixed server roles, and to members of the db_owner fixed
> > database roles. These permissions are not transferable.
> >
> > They can do this:
> >
> > This example creates a database and alters it to add a new 5-MB data
> > file.
> >
> > USE master
> > ALTER DATABASE Test1
> > ADD FILE
> > (
> > NAME = Test1dat2,
> > FILENAME = 'c:\Program Files\Microsoft SQL
> > Server\MSSQL\Data\t1dat2.ndf',
> > SIZE = 5MB,
> > MAXSIZE = 100MB,
> > FILEGROWTH = 5MB
> > )
> > GO
> >
> > What i want is to provide the db_owner but we need to restrict the
> > maxSize of the database.
> >
> >
> > Sincerely,
> > Yusbel Garcia
>

DB Size

One of my DBs is about 10 GB, the autogrowth creates performance problems. I manually increase the size as needed. Any suggestions of a better solution to this. May be a job that increases the size at a specific time?
Thanks
Niles,
you could simply make the database file size extremely large in one alter
database statement and do this out of hours.
Autogrowth is a double edged sword as it makes maintenance easier but the
DBA loses control of when such increases occur, potentially resulting in
them happening during peak hours. The same would apply to an alert.
You could also schedule a job to run out of hours which examines the results
of sp_spaceused and then determines if an increase in size is required.
HTH,
Paul Ibison
|||Yes I agree with Paul. Why not make the DB size something large enough so
you don't have to worry about it for a year or more? If you know it will
get to 20GB in a year then make it that large now. There is no penalty for
too much free space but there is a big one for too little.
Andrew J. Kelly SQL MVP
"Niles" <anonymous@.discussions.microsoft.com> wrote in message
news:7435AFFE-47B9-4520-945E-9ED198C6B258@.microsoft.com...
> One of my DBs is about 10 GB, the autogrowth creates performance problems.
I manually increase the size as needed. Any suggestions of a better
solution to this. May be a job that increases the size at a specific time?
> Thanks

DB Size

One of my DBs is about 10 GB, the autogrowth creates performance problems.
I manually increase the size as needed. Any suggestions of a better solutio
n to this. May be a job that increases the size at a specific time?
ThanksNiles,
you could simply make the database file size extremely large in one alter
database statement and do this out of hours.
Autogrowth is a double edged sword as it makes maintenance easier but the
DBA loses control of when such increases occur, potentially resulting in
them happening during peak hours. The same would apply to an alert.
You could also schedule a job to run out of hours which examines the results
of sp_spaceused and then determines if an increase in size is required.
HTH,
Paul Ibison|||Yes I agree with Paul. Why not make the DB size something large enough so
you don't have to worry about it for a year or more? If you know it will
get to 20GB in a year then make it that large now. There is no penalty for
too much free space but there is a big one for too little.
Andrew J. Kelly SQL MVP
"Niles" <anonymous@.discussions.microsoft.com> wrote in message
news:7435AFFE-47B9-4520-945E-9ED198C6B258@.microsoft.com...
> One of my DBs is about 10 GB, the autogrowth creates performance problems.
I manually increase the size as needed. Any suggestions of a better
solution to this. May be a job that increases the size at a specific time?
> Thankssql