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.

Thanks.