Home » RDBMS Server » Security » Oracle BECOME USER (Oracle 10G, Solaris)
Oracle BECOME USER [message #506503] Mon, 09 May 2011 08:56 Go to next message
Messages: 117
Registered: December 2007
Senior Member
Hi All,

I found one command as "audit BECOME USER by access;"
Not sure what the command will do.
Can you please explain the same?

Re: Oracle BECOME USER [message #506513 is a reply to message #506503] Mon, 09 May 2011 09:52 Go to previous messageGo to next message
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
"BECOME USER" is a system privilage.read oracle documents to know more about this privilage.
audit BECOME USER by access;
By this you are auditing the privilage.

Re: Oracle BECOME USER [message #506520 is a reply to message #506503] Mon, 09 May 2011 10:24 Go to previous message
Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
BECOME USER is an internal privilege.
You cannot use it.
It is used by imp or data pump to full import or import fromuser/touser.

"audit BECOME USER by access;" acticates the audit of the usage of this privilege.
You can find the audit records in dba_audit_trail view.

Previous Topic: Oracle Internet Directory - Tables
Next Topic: To find out whic row is locked by the particular user (2 Merged)
Goto Forum:

Current Time: Sun Sep 19 08:44:19 CDT 2021