Script de la marica

users: cambio de password sys.sql

dba_users; antes en 10g se podian ver los passwords en esa vista.

SQL> select name, password from sys.user$ where name like 'LWTSADM1';

lwtsadm1  

NAME                           PASSWORD
------------------------------ ------------------------------
SYS                            8A8F025737A9097A

SQL> alter user sys identified by password;
alter user O2C_OWNER identified by password;

User altered.

SQL> connect sys as sysdba
Enter password: 
Connected.
SQL> 

SQL> alter user sys identified by values'8A8F025737A9097A';

User altered.

SQL> connect sys as sysdba
Enter password: 
Connected.