Sunday, February 19, 2012

dbo rolemembership and files size of database files

Hi
If I create a database and give to the database user
dbo role membership he is able to change size of datafiles
mdf and ldf. How can i suppress that so that this is no longer
possible?
Kind regards
MickeyDBO should not have this right by default. Make sure the user is also not
a member of
sysadmin or diskadmin fixed server roles.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

No comments:

Post a Comment