>I'm working in a a place so locked down they want me to use SSRS to extract some data and export to another system but .
>
>I can't have access to the data or even a test version.
>
>A quote
>
>yes but thinking about it we shouldn’t have copies of finance data anywhere apart from live or test servers! you may have to develop “blind” and then ask the DBA team to deploy to UAT for you to test?
>
>WTF
Perhaps you can ask for precise structure of databases. Then build your own test database(s). Then build test solution and let DBA eggheads
'test it'. It will of course fail, but that will be not due to your fault, but due to complexity of security environment.
Then you build another version.
Then they test it again.
Repeat 5-6 times till cooked to perfection :-)
Bill them (Fast&) FURIOUS all along !!
( Security comes at cost. We all know (and some agree) to that {g} )
By the time they are both happy AND secure - you could become rich!
Cheers :)