How can we help you today? How can we help you today?

Remove GRANT statements from SQL Script sections

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? 

Sean Kelly
0

Comments

2 comments

Sort by
  • Christian Perez
    Official comment

    Hi Sean,

    Thanks for reaching out to Redgate Support regarding your SQL Doc inquiry. I did a search through the codebase repository and SQL Doc Documentation, but unfortunately I am not seeing a method to exclude grant/deny/revoke statements from the SQL Script section of documented objects outside of exluding SQL Scripts entirely from the documentation.

    I would recommend you consider creating an entry on our User Voice Forum here: https://redgate.uservoice.com/forums/936348-sql-toolbelt-essentials

    Our User Voice Forum allows Redgate End Users to create potential enhancement requests that are then voted on by the community, if other members vote on your topic, it can then be implemented by development in a future release.

    Let me know if you have any follow up questions.

    Christian Perez
  • Thomas Bishop

    Thanks for checking and confirming that. That’s a bit disappointing, but I understand the limitation. I’ll go ahead and submit a suggestion on the User Voice forum as recommended. Appreciate your help! @ geometry dash lite

    Thomas Bishop
    0

Add comment

Please sign in to leave a comment.