Re: drop user

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 30 Sep 2002 19:47:29 GMT
Message-ID: <3D98AA3D.F41E9EB3@exesolutions.com>

Paul Brewer wrote:

> "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

Or, alternatively, remove CREATE SESSION.

Daniel Morgan Received on Mon Sep 30 2002 - 14:47:29 CDT