Re: Security changes in 11g
Date: Sat, 7 Jun 2008 09:27:14 +0100
<ec54b056-14c7-4728-8393-f47b46c1f041_at_y21g2000hsf.googlegroups.com>, Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com> writes
>On Jun 4, 11: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
>Your 'CONNECT /' is missing ' AS SYSDBA', which is mandatory since 9.2
>or even 9.0.1 (since I skipped that release altogether I am not sure.)
>Did you jump to 11g straight from 8i?
Not necessarily. Could be an OS authenticated dba user.
But since the OP doesn't say what the actual problem is, that could be the source of the problem.
-- Jim SmithReceived on Sat Jun 07 2008 - 03:27:14 CDT