alter user identified externally

From: genegurevich@xxxxxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
Date: Fri, 27 Jul 2007 09:14:03 -0500

Hello.

I have not been able to alter users to "identified externally" unless the
user has sysdba privilege:

connect NonDba/password
alter user NonDba identified  externally
ERROR at line 1:
ORA-01031: insufficient privileges

connect Dba/password
alter user NonDba identified externally

works successfully

Is that the restriction that oracle places on who exactly may execute this
command (I'm using oracle 10.2)
or is there a way to work around it?

thank you

Gene Gurevich


--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

RE: alter user identified externally
From: Bobak, Mark

Re: alter user identified externally
From: Niall Litchfield

References:
- RE: tuning an index build
  - From: Mark W. Farnham

alter user identified externally

Other related posts: