Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

get-DbaUserPermission does not drop STIG schema #5083

Closed
PianoMatt opened this issue Feb 11, 2019 · 0 comments · Fixed by #5135
Closed

get-DbaUserPermission does not drop STIG schema #5083

PianoMatt opened this issue Feb 11, 2019 · 0 comments · Fixed by #5135

Comments

@PianoMatt
Copy link

I noticed that get-DbaUserPermission does not drop the STIG schema after a successful execution. I believe the problem is that the code issues the "endSQL" within the context of a user database, and it needs to be in the tempdb.

           Write-Message -Level Verbose -Message "Deleting objects"
            try {
                $db.ExecuteNonQuery($endSQL)
            } catch {
                # here to avoid an empty catch
                $null = 1
            }
@potatoqualitee potatoqualitee transferred this issue from dataplat/docs Feb 13, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant