Security changes in 11g
From: JAW <jwilliam_at_aglresources.com>
Date: Wed, 4 Jun 2008 12:39:49 -0700 (PDT)
Message-ID: <727a8b3b-06dd-43c8-91e8-63683240d52f@m73g2000hsh.googlegroups.com>
Date: Wed, 4 Jun 2008 12:39:49 -0700 (PDT)
Message-ID: <727a8b3b-06dd-43c8-91e8-63683240d52f@m73g2000hsh.googlegroups.com>
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
rem
rem
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
@/tmp/tmp.sql
host rm /tmp/tmp.sql
set pages 24 lines 80 feedback o
Received on Wed Jun 04 2008 - 14:39:49 CDT