I am unable to alter a database table with ddl admin permission. I get the following error:
"You are not logged on as the database owner or system administrator. You might not be able to save changes to tables that you do not own."
I do not want to grant the user performing this task db_owner. Is there a work around this?
Any help will be appreciated.