Invoke-DbaDbDataMasking not working on a particular table #10268
Unanswered
batman1975
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Hi
I've been using dbatools to anonymise some data before moving across to Fabric. I was testing on a copy of a client table, copied using a 'select * into' statement. It's working fine on the copy, but when I apply it to the original table, I receive the message 'Failed during execution | CREATE TABLE permission denied in database 'tempdb'.'. The table itself has around 2500 rows and around 60 columns, 18 or which are configured to be anonymised. It also has two unique indexes, one of which is the primary key.
I have just tried removing all foreign key references to the table which made no difference. Are there any other considerations I need to make to get this working? Any advice would be greatly appreciated.
Beta Was this translation helpful? Give feedback.
All reactions