Re: cleanup user's account

Sunny Siu (siu_at_uta.edu)wrote:
>
> How do I remove user's tables and associated objects and then finally drop
> the account? I know that I can easily drop an account using the Motif-based
> Svrmgr. How about cleaning associated objects?

drop user user_name cascade;

-- 
                       \\|//
                       (0-0)
           +-----oOO----(_)-----------+
           | Brian P. Mac Lean        |
           | Database Analyst         |
           | brian.maclean_at_teldta.com |
           | http://www.teldta.com    |
           +-------------------oOO----+
                      |__|__|
                       || ||
                      ooO Ooo