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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to delete a user without droping all objects owned by this user.

Re: How to delete a user without droping all objects owned by this user.

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Tue, 12 Jan 1999 16:07:37 +0100
Message-ID: <369B6538.E1A7BCB@vnl.nl> 





Isn't it drop user <user_name>; instead of drop user <user_name> cascade?
Apart from that - why would you drop a user when you want to keep
all of it's objects? WOuldn't it be easier to revoke the connect privilege?



Truong Quang Phan wrote:



> Hi Netter,


>


> Is there a way that I can delete a user without removing the user's objects.


>


> Thanks in advance,









Received on Tue Jan 12 1999 - 09:07:37 CST












Original text of this message













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