patternsqlMinor
SQL Server: does ddladmin rights contain datareader and datawriter rights to the database?
Viewed 0 times
thedatareadersqlcontainandrightsdatawriterdatabaseddladmindoes
Problem
Does
db_ddladmin fixed database role include db_datareader and db_datawriter rights, so that you don't have to grant those rights explicitly?Solution
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 could make your own role and make it be a member of the db_ddladmin, db_datareader and db_datawriter roles.
Context
StackExchange Database Administrators Q#4965, answer score: 7
Revisions (0)
No revisions yet.