Re: Security changes in 11g

From: <fitzjarrell_at_cox.net>
Date: Wed, 4 Jun 2008 13:01:48 -0700 (PDT)
Message-ID: <3a8c9e20-ba15-4756-b49f-92c4ad0094ea@y21g2000hsf.googlegroups.com>


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
> 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

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

Original text of this message