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

3 Answers 3


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.


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


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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