Re: How to know the user password?

From: <sokol_at_opsb.ru>
Date: Wed, 30 Sep 1998 15:14:03 GMT
Message-ID: <6uthrq$ith$1@nnrp1.dejanews.com>

In article <3615301f.3784813_at_news.twsc.pouchen.com.tw>, violin.hsiao_at_mail.pouchen.com.tw (Violin) wrote:
> Hello,
> I have a question,maybe you can help me!
> I have several users on my database(7.3)
> Of course each user with their own password.
> But how to know every user's password?
>
> 'Cause not all the users are created by me,
> I don't know some users' pwd.
> 'Cause I can't change the original pwd,
> the command is not proper for me:
> ALTER USER user IDENTIFIED password.
>
> So,how to know the user's password?
> PLEASE give me some tips,I'll appreciate for your help!
> And please Cc to : violin.hsiao_at_mail.pouchen.com.tw,Thank you :)
>

Go to http://www.embarcadero.com/

download DBArtisan (DBA tool)

click on "Extract" for selected user (DBArtisan extract DDL for user)

see sample:

CREATE USER EGOR IDENTIFIED BY VALUES 'F2AFD905D25C3719'     DEFAULT TABLESPACE USR
    TEMPORARY TABLESPACE SYSTEM
    QUOTA UNLIMITED ON USR
    PROFILE DEFAULT;
GRANT SKL TO EGOR;
ALTER USER EGOR DEFAULT ROLE SKL; remeber phrase: "VALUES 'F2AFD905D25C3719'"

next: alter user EGOR identified by bla-bla-bla;

.....
.... doing very secret actions ....
......

at end: alter user EGOR identified by VALUES 'F2AFD905D25C3719';

Vuala!

Luck.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 30 1998 - 10:14:03 CDT