Re: how to clear a schema without dropping the user?

You could create a SYSTEM-owned proc that does a drop user command and give that user execute privs on the procedure. Inside the proc you should, of course, do some checks to prevent dropping system users.

In 8i plsql the syntax is very simple: execute immediate 'drop user '||user. Really does not take much effort to develop.

Kenny Yu wrote:

> I need to give a schema owner the effect of 'drop user sch_owning_user
> cascade' without him having dba priviledge. That is, I want to keep the
> user's acocunt/password, tablespace etc, but need to clead all tables,
> packages, sequences, etc. Short of getting a list of objects from obj view,
> is there a simple way?
>
> Kenny
Received on Thu Oct 24 2002 - 01:51:21 CDT