January 29, 2007 at 2:35 pm
Hello,
I have a situation where users can login with enterprise manager to sql2000 server and edit their db. The problem is that I do not want to give them the ability to select the autogrow feature. Is there a way to disable this or at least remove the permission from a login to do this.
Thanks for any information.
Brian
January 29, 2007 at 3:01 pm
IF the users have db_owner role, then no, they have complete control over the database.
Check if ddl_admin role is sufficient.
SQL = Scarcely Qualifies as a Language
January 30, 2007 at 12:40 am
The question is do they realy need such permissions which they already have? I mean the DBO role. One of the main DBA rules is to give only necessary permissions to the others not all you can to
If they need to create, alter database objects this can be granted in other ways. It depends on what the users realy need
January 30, 2007 at 7:32 am
You can always set up a job to scan for autogrow being set in each db and email yourself if it is. Doesn't prevent it, but it does allow you to know it happens.
If it's a big deal because of disk space, then you should go to a manager and handle it administratively.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply