Security changes in 11g

From: JAW <>
Date: Wed, 4 Jun 2008 12:39:49 -0700 (PDT)
Message-ID: <>

In the past the dba has been able to use the below script prior to 11g and be able to connect to schema without password to resolve issues.

It does not seem to work in 11g.

cat buser.sql
set pages 0 lines 200 trims on feedback off verify off echo off timing off
define USERS = '&1'
connect /
spool /tmp/tmp.sql
select 'ALTER USER &USERS IDENTIFIED BY VALUES '  ||''''||Password||''''||';'
  from DBA_USERS where Username = UPPER('&USERS'); spool off
alter user &USERS identified by sneaking; connect &USERS/sneaking
host rm /tmp/tmp.sql
set pages 24 lines 80 feedback o Received on Wed Jun 04 2008 - 14:39:49 CDT

Original text of this message