Re: Impersonate a Oracle User

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 8 Sep 2005 08:43:36 -0700
Message-ID: <1126194216.815098.165340@g14g2000cwa.googlegroups.com>

I was thinking what Martin probably wants to do is switch to using another user id without knowing the password. A DBA has been able to do this from at least version 7 to 9.2 and probably in 10g and 6.

I have posted on how to create users in a new database with their current passwords on metalink and I made a quick search here to see if I have posted this in the past. Instead I found where Tom Kyte posted the code.

http://groups.google.com/group/comp.databases.oracle.misc/browse_frm/thread/c308416aad70a3eb/2cb363debd4d832c?lnk=st&q=change+user+group:comp.databases.oracle.*+author:Mark+author:D+author:Powell&rnum=3&hl=en#2cb363debd4d832c

Only a DBA privileged user can do this so I do not think it is a significant security issue.

HTH -- Mark D Powell -- Received on Thu Sep 08 2005 - 10:43:36 CDT