Re: Oracle equivalent to unix 'su - username'... connecting as someone else

One would want to connect as a non-dba to do things like grant object privileges on objects the non-dba owns to others.

landmass_at_iname.com wrote:
: Easiest way, is to look at the dba_users table, which holds an encrypted
: version of the password. If you do a "select username, password from
: dba_users where user_name = '????';", and then save this to a file - DO NOT
: DELETE IT. You can then use the 'alter user xxxx identified by yyyy;'
: statement to change the users password to something that you know.... When
: you have finished, you can change it back to its previous value: alter user
: xxxxx identified by values '<paste password string from file here>';

Really?? Must try this, I didn't know this was a consistent cypher. Rather defeats the purpose of encrypting the password, though.

Regards,
jh

--
Jared Hecker	| HWA Inc. - Oracle architecture and Administration
jared_at_hwai.com	|  ** serving NYC and New Jersey **