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: Unexpected Oracle error message

Re: Unexpected Oracle error message

From: Marcus Reichardt <mr_at_diamanda.hh.eunet.de>
Date: Wed, 01 Jul 1998 13:52:37 +0200
Message-ID: <359A2305.438D@diamanda.hh.eunet.de>


I dont't know much of oraperl, but it seems like there are two sources of this error:

  1. In general, executing DDLs like DROP TABLE might cause unpredictable behaviour on any open cursors. So be sure to close the transaction by COMMITing explicitly before executing DDLs.
  2. Dropping/creating uses in particurlar might not succeed if there are open transactions on the affected user. Also the object privileges to be granted to the newly created user on the existing user's objects might involve re-connecting to the latter one, as the privileging scheme does not allow a user to GRANT another user's object privileges, so one must use insecure techniques like public passwords or highly system privileged accounts. Thus I would avoid creating users on a regular base in the course of operation. Isn't it possible just to drop/re-create the new user's objects?

Marcus Reichardt
Consultant Received on Wed Jul 01 1998 - 06:52:37 CDT

Original text of this message

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