Forgive my ignorance but...
The MSDN document was a little vague on who could do this:
Requires ALTER permission on the database.
But I know that there are some commands that can alter the database,
under db_owner but some items require sysadmin (modify file).
It appears that this can this be done by members of db_owner by default or is this reserved for the sysadmin? If db_owner members can do this then what would we need to change to prevent it or at least limit who can do this? I tried this under a db_owner account on a test database.
Sorry, I'm just a programmer that sometimes has to wear a DBA hat (more and more) for some DBA actions. I document what I do and tell the DBA's what I plan on doing (or did) and provide the script.
"There is nothing so useless as doing efficiently that which should not be done at all." - Peter Drucker