Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> alter user identified externally

alter user identified externally

From: <genegurevich_at_discover.com>
Date: Fri, 27 Jul 2007 09:14:03 -0500
Message-ID: <OF3F4D449C.327BA6D8-ON86257325.004DBA01-86257325.004E2C8E@discover.com>


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
Received on Fri Jul 27 2007 - 09:14:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US