Space Allocation

  • Hi All,

    A DBO on my server can change the allocated space for his database. He can actually increase it to any size, which can create a problem for me.

    Is there any way to restrict the DBO's from allocating more space to their respective databases ?

    Any help is appreciated.

    Thanks,

    Chandra

  • I´m not sure you can restrict that. Not from SQL at least. Maybe ask a win2000 if it can be done.

    Or remove permissions from them and you create the databases for them.

  • You cannot limit their ability to change. However, do they really need DBO rights, can you put them on some other writes option and provide the needed access, which will prevent the worry.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • This is a Development Server and users do need/have DBO privileges. Even if I am able to restrict it to certain amount it would be great.

    Thanks for your responses though.

  • Here are a couple of things you might consider.

    If all the database on the server needed to grow no bigger than the allocated size, and the drive where the data and transaction logs resided where only used for data and transaction logs, you could allocate a dummy file that took up all the available space. This way if they tried to grow there database there would be no space on the disk. Of course you would also want to make sure they could not allocate a secondary file on another disk. I really don't like this method, but it might work.

    Alternatively you could set up an ALERT of some kind that informs you whenever the allocation of a database changes. When you get the ALERT you to talk to the DBO that changed the allocation. You might want to take a big stick with you when you have the allocation discussion.

    Ok now that I've said that, please disregard these stupid ideas.

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply