Is there a way to create or change a special role for creating tables? Our software developer team has db_datareader
and db_datawriter
roles but they can not create new tables.
I read this article related to database level roles. I don't want to grant db_ddladmin
role because there is too much permissions in this role.
So my question is how can i give creating and deleting tables permissions for a database? Views, procedures and functions are okay too. All I need is I don't want to grant permissions related to security, login or backup operations.