• I'd also add to the comments about production and use of change management procedures. I'd never allow a procedure that automatically granted changed permissions to users to run in production (or for that matter test). Permissions to production data should be controlled, and in my view test should replicate the live environment - with the exception of the specific change that you are testing.

     



    Niall Litchfield
    Senior DBA
    http://www.niall.litchfield.dial.pipex.com