In SQL Server 2019, I have created a user defined database role
Now I want to grant following permissions to
MyDbRole for all tables in the database.
CREATE, SELECT, UPDATE, DELETE, ALTER
Question: What minimal permissions I need to achieve this task. If I were to ask a DBA to give me a permission so I can grant following to
MyDbRole, what permission should I ask a dba for. I'm guessing, it has something to do with
WITH GRANT OPTION, but I am not quite sure as to exactly what permission I need?
Update: Please note that we are not allowed to use built-in database roles such as db_datawriter, db_ddladmin as these would give more permissions to a user than it's needed). Ref