Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Does db_ddladmin fixed database role include db_datareader and db_datawriter rights, so that you don't have to grant those rights explicitly?

share|improve this question
up vote 7 down vote accepted

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.

share|improve this answer

Except for db_owner, the fixed db roles have no overlap with each other.

You can see this here ("Permissions of Fixed Database Roles") where the newer GRANT options are listed against the db_dostuff roles

share|improve this answer

I agree with Mr. Denny. The DDL Admin role is exclusive of the Data Reader/Writer roles. One is for DDL and the other two are for DML.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.