I want to allow certain user to create/modify objects on a database(tables, views, sp's, functions, schemas etc) and don't want to give db_owner.
I thought I could do it with the db_ddladmin role, but somehow that doesn't wort as expected. The error messages i get is that are like this:
Your are not loggend on as the database owner or system administrator. You might not beable to sache changes to tables that you do not own. Table dbo.MyTable is set to read only, user doesn't have enough right on this table.
Any idea how i can achieve my goal?