Eric M Russell (8/26/2016)
MMartin1 (8/26/2016)
I guess things like this happen when there is no effort to learn what the other roles are, like ddl admin.But you probably know that db_ddbadmin will grant them permission to truncate or drop tables.
Oh yes. I was referring to your earlier post about giving a sysAdmin (more than needed) to some developers who would need to create tables. Just grant the db_ddlAdmin for the database where they need to work.
Granting developers and other users membership in the SYSADMIN ...
----------------------------------------------------