Re: Q: Become user

Chris Selwyn (chris_at_perihelion.co.uk) wrote:

: Does anyone know of a method for a user with DBA privileges to "Become"
: another user temporarily?
 

: --
: Chris Selwyn
: Senior Consultant
: Perihelion Software
: email: chris_at_perihelion.co.uk tel: +44 1749 344203

I too would like to do this. We have production user where nobody knows the password (not even us DBAs). Everything is done through role grants. Whenever you need to get in as the user, you have to change the password which messes up links on other systems. After looking into the BECOME USER privelege, I gather that this is only used by import. Can Oracle add the "Super User" ability in future releases?

         _______               _____       ______                     
        /      /      /       /     |     /     /          /           
       /______/____  /___    /     /     / / / /___       /'__         
      /   \   /   / /   /   /     //  / / / / //   //  / ///  /                
     /     \ /___/ /___/   /_____//__/|/ / / //___//__/|///  /            
              (404) 493-2262  rdumouli_at_lanier.com

********************************************************************
#include <corporate_disclaimer>  *** If Unix and Oracle were perfect
#include <release_of_liability> *** I'd be fishing on the beach or 
#include <typological_denial>  *** snowboarding down a mountain      
#include <praise_for_FSU>     *** instead of typing this with VI.   
********************************************************************