31 lines
455 B
Plaintext
Executable File
31 lines
455 B
Plaintext
Executable File
set pages 0 lines 256 feedback off
|
|
|
|
select
|
|
'alter user ' ||name|| ' identified by values '''|| password||''';'
|
|
from
|
|
user$
|
|
where
|
|
password is not null and
|
|
name not in
|
|
('SYS',
|
|
'SYSTEM',
|
|
'OUTLN',
|
|
'GLOBAL_AQ_USER_ROLE',
|
|
'DIP',
|
|
'DBSNMP',
|
|
'WMSYS',
|
|
'XDB',
|
|
'ANONYMOUS',
|
|
'ORACLE_OCM',
|
|
'APPQOSSYS',
|
|
'XS$NULL',
|
|
'SYSBACKUP',
|
|
'AUDSYS',
|
|
'SYSDG',
|
|
'SYSKM',
|
|
'GSMADMIN_INTERNAL',
|
|
'GSMUSER',
|
|
'GSMCATUSER'
|
|
)
|
|
/
|