Re: Security changes in 11g
Date: Wed, 4 Jun 2008 13:01:48 -0700 (PDT)
On Jun 4, 2:39 pm, JAW <jwill..._at_aglresources.com> wrote:
> 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 '
> 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
Have you checked the contents of the /tmp/tmp.sql script? Or verified what the DBA_USERS view contains?
David Fitzjarrell Received on Wed Jun 04 2008 - 15:01:48 CDT