Re: statement for dropping all objects of a certain user ?

Michael Agbaglo <byteshif_at_cs.tu-berlin.de> wrote in article <336CCD75.94DCCA4_at_cs.tu-berlin.de>...
> statement should be processable in sql-plus -thanks.
>

If you need drop *all* concerning user, say, dropuser ( including grants and privileges ) you can use command
DROP USER dropuser CASCADE;
Then you can recreate user. Via such method you can be sure that you should never get messages that object cannot be deleted because child exists and so on. However you *must* consider the fact that after recreation of user his account would have another USERID.
 You must have neccessary privileges, of course, and cannot, i believe, drop yourself.
Yours s.
 Uldis Pavuls

pavuls_at_konts.lv Received on Mon May 05 1997 - 00:00:00 CDT