DB2 10.5 on Windows
I am getting ready to copy the production database to our test server and then scrub all the sensitive data. What I would like to do is to script out all the permissions on the test database before I restore the production database.
Using TOAD, I can click on a user and view details and it will script all the grants for me, but there are about 3 dozen users in test and I don't want to do each one by hand. I would love to capture the SQL that TOAD is generating to get that script and then I could run if for all the users.
Does anyone have a script like this? That will give me the grant statements for all the users on a given database? I could do the one at a time method but that will be a real pain.