April 17, 2015 at 12:07 pm
Hello all
I have a sql server 2012 server and I need to prevent the users from creating new schemas by mistake.
Is there any way to revoke that permission alone but still letting the user to create their own objects in dbo (yes I know that shouldn't be in dbo but that is another issue)
Thanks in advance?
April 17, 2015 at 3:32 pm
Exactly what you're asking wouldn't be possible. But to be fair; no one ACCIDENTALLY creates a schema...that's just not something that happens.
If these are developers, it's generally best to leave them alone in the development environment. Take regular backups and ensure they know they are responsible for their own mess.
If you have developers working in a prod/uat environment, then I hope the SQL gods have mercy on your soul...sorry.
April 20, 2015 at 8:06 am
The only time I see users creating thier own schemas, is when they haven't had "dbo" set as their default schema. In that case, creating objects will cause a schema to be created for them.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply