automatically grant all DML permission on all MS SQL schema
Posted on 2016-09-23
we are now undergoing the permission review and we tried to make less database role, so I combine all permission from previous role to a single role so all developer under that role will all have the same permission now.
one thing, is that true that all newly created schema will not automatically grant full DML permission for a role ? must be manually when each time a new schema created?
or as long as the database role also the owner of that user database, then ANY NEW CREATED schema will be able to fully DML able ?