Thursday, September 2, 2010

Be careful to grant dbCreator server role to the user

It is common that vendors ask for permission to create databases (or they applications need) on your servers and most of DBAs I have seen immediately grant them dbCreator server role. But they are not aware that members of that role are able to DROP/ALTER any databases on the entire server regardless of whether or not you even have a user account in the database.Did you really want that??

The right approach is to grant CREATE ANY DATABASE permission and then the user is able to DROP/ALTER he/she owns.

4 comments:

Nike shox shoes said...

Only this form is fully prepared, carefully organized and promptly summarized, can it gain the actual effect

Nike shox shoes can surely not let you down,romance yourself with nike shox

Ters said...

Poezi Dashurie

Ters said...


A collection of love and sweet sms. Here you can find the most new and romantic sweet love sms

Sweet Love Sms

Love Sms

Ters said...

Sweet Love Sms

The biggest collection of love quotes you can find here on sweet love quotes.