Removed specific privilege requirements for transaction commands

Transaction commands can inherit their specific privilege requirements from the statements run inside the transaction.

This does not however remove the need for a user to be authenticated if auth=true.