I'm generating a SQL Doc file from a database and I want to remove any and all permissions and roles from being shipped with the documentation. I'm able to remove the permissions/security sections, however within the SQL Script sections of each object it's generating GRANT statements. This is exposing security objects (Roles/Users) which were granted permissions to that object. This behavior is shown across at least Tables, Stored Procedures, Functions, and Views.
Is there any way to modify/change the behavior of the SQL Script generation to not generate GRANT statements to an object?
I'm generating a SQL Doc file from a database and I want to remove any and all permissions and roles from being shipped with the documentation. I'm able to remove the permissions/security sections, however within the SQL Script sections of each object it's generating GRANT statements. This is exposing security objects (Roles/Users) which were granted permissions to that object. This behavior is shown across at least Tables, Stored Procedures, Functions, and Views.
Is there any way to modify/change the behavior of the SQL Script generation to not generate GRANT statements to an object?