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: drop user

Re: drop user

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Sun, 29 Sep 2002 22:25:24 +0100
Message-ID: <3d987e6c$1_2@mk-nntp-1.news.uk.worldonline.com> 





"xx32" <i.dont.want.sp_at_m.com> wrote in message
news:3D9495CB.6060305_at_m.com...


> is it possible to have a schema without a user?

>



Strictly speaking; no, afaik (up to 8.1.7).
But you can always 'alter user schema_owner account lock'.



In prehistoric versions you could revoke all the schema owner's privileges,
once the objects had beeen created...



HTH,



Paul
Received on Sun Sep 29 2002 - 16:25:24 CDT












Original text of this message













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