Re: Security changes in 11g

JAW 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

Security has been tightened in Oracle 11g and, I expect, will continue to be tightened with each subsequent release.

Open SQL*Plus on the server and log in using / as sysdba.

Does it work?

Nowhere in your post do you reference any error so you leave us wondering what the issue you are asking about actually is. Clarity in question generally generates clarity in responses.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org