SQLTeam.com | Weblogs | Forums

DDL Admin Role


#1

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.

Thanks.


#2

For this you may check this URL:
https://technet.microsoft.com/en-us/library/ms164237(v=sql.105).aspx