Re: Superuser

Jan-Peter Meyer wrote:
>
> Hi
> I am looking for a way of connecting as a user without
> knowing his password assuming, that I have
> system priviledges. I need this to run a batch job in
> the users environment, knowing only his username.
> (something like su in UNIX)
>
> Any help appreciated
>
> --
> ---------------------------------------------------------------
> Jan-Peter Meyer Siemens Business Services
> jan-peter.meyer_at_scg.de SBS IS E 1
> (49) (0)89 636 51729
> ---------------------------------------------------------------

If you are runing version 7.+ then it can be done without a problem if you have DBA privileges.

Oracle stores encripted passwords in a data dictionary table DBA_USERS. So you can save user's encripted passwor as a string, replace it with a new one (ALTER USER user1 IDENTIFIED BY new_passwd) and log on with this new password. When you are done you can restore original password with

    ALTER USER user1 IDENTIFIED BY VALUES encripted_string; So at the end user will be able to log on with his old password without and his password will still be unknown to you.

I've seen couple of scripts providing this functionality on the internet. You could find one of them on

        http://www.oramag.com/code/tip10256.html

Mail me if you could not find any of them.

Regards, Jure

-- 
 ===============================================================
 ! Jurij Modic                            Republic of Slovenia !
 !  tel: +386 61 178 55 14                Ministry of Finance  !
 !  fax: +386 61  21 45 84                Zupanciceva 3        !
 !  e-mail: jurij.modic_at_mf.sigov.mail.si  Ljubljana 1000       !
 ===============================================================