Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

3 Answers 3

up vote 5 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
add comment

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
add comment

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
add comment

Your Answer

 
discard

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.