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

Scrub passwords from Sql History history

Hi

I'm looking for a convenient way to scrub historical passwords for instance for "Create User" statements.
They are kept in SQL History's query history, even if I remove the password before closing the file.

Note that I do not want to remove the script from history. Since I use it for reference. Is there a way- or must I remove the query completely?

Also, it would be awesome if there was a scrub all secrets from history function. Maybe It exists and I missed it?

Best
Joel
Joelg
0

Comments

1 comment

Sort by
  • Dan_J
    Hi @Joelg

    Thanks for your question!

    Unfortunately this functionality does not currently exist in SQL Prompt. I appreciate this would be useful to you and so encourage you to log a feature request on our SQL Prompt UserVoice page - https://redgate.uservoice.com/forums/94413-sql-prompt. That way our development team will have visibility of this and can consider it in future releases of the product.
    Dan_J
    0

Add comment

Please sign in to leave a comment.