db_ddladmin fixed database role include
db_datawriter rights, so that you don't have to grant those rights explicitly?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
I don't believe so. It should only allow them to run DDL not access tables.
You could make your own role and make it be a member of the db_ddladmin, db_datareader and db_datawriter roles.
You can see this here ("Permissions of Fixed Database Roles") where the newer GRANT options are listed against the