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

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus script dropping conected user

Re: sqlplus script dropping conected user

From: <sybrandb_at_hccnet.nl>
Date: Thu, 13 Sep 2007 18:56:44 +0200
Message-ID: <jsqie357os0dk3qniiopsdm7es7i11bjf2@4ax.com> 





On Thu, 13 Sep 2007 15:54:50 +0200 (CEST), Mladen Gogala
<mgogala_at_yahoo.com> wrote:



>connect / as sysdba

>startup force restrict

>

>Then you can execute your script.




Most 3rd party apps I know grant connect, resource, dba to the
application owner.


I've even seen an app with owner sa password sa.


-- 
Sybrand Bakker
Senior Oracle DBA


Received on Thu Sep 13 2007 - 11:56:44 CDT












Original text of this message













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