[Info-vax] [OT] Oracle server password removal - VMS 6.2

[supervinx]

Touché :)

I was writing from another PC and I hadn't the details handy ...

Here they are:

VMS 6.2 / Oracle V7 (Oracle7 Server Release 7.1.5.2.3)

1) Login as ORACLE user (SYSTEM is not enough).

2) SQLDBA

3) CONNECT INTERNAL

4) SELECT USERNAME FROM DBA_USERS; In order to get a list of the DB users.

5) ALTER USER xxx IDENTIFIED BY password; xxx is an user chosen from
the list 4), password is a new password chosen by us.

6) CONNECT xxx/password or EXIT;

Then we can login with SQLPLUS.

https://forums.oracle.com/forums/thread.jspa?messageID=10638742


-- 
                                 _            
 ___ _   _ _ __   ___ _ ____   _(_)_ __ __  __
/ __| | | | '_ \ / _ \ '__\ \ / / | '_ \\ \/ /
\__ \ |_| | |_) |  __/ |   \ V /| | | | |>  < 
|___/\__,_| .__/ \___|_|    \_/ |_|_| |_/_/\_\
          |_|