Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is it possible to apply restrictions on how much data a user / login may store in a database? I found no way to apply such restrictions to schemas, for instance.

If there is no built-in mechanism then I'm curious if someone had implemented some kind of it.

Seems a bit ridiculous, I know but we have some users and want them to restrict writing too much data into WorkDB so that their activities (queries, inserts) wouldn't eat out all the resources.

Resource Governor can only maintain CPU/RAM.

Environment: SQL Server 2008 R2 Enterprise edition.

share|improve this question

2 Answers 2

There is one option as I know: one user - one database. Set Initial Size and disable Autogrowth (database options).

share|improve this answer
    
Yes, this is first that comes up. Anyway, thanks for that =) –  Vlad Ogay Jan 10 '12 at 15:08

No. You can howver restrict the DB size (garik already pointed out that) but also you can restrict individual files and thus restrict filegroups, and you can assign specific user tables to specific filegroups. Is a workaround, but it can work. See Files and Filegroups Architecture

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.