Dropping users

Database
Enthusiast

Dropping users

I am having issues with user clean on my Teradata systems due to drop user failing for any of the following reasons.

  • Users have objects under them
  • Proxy user access associated with the
  • Dead locks cause system to abort the drop statement

Does anyone else have is problem or have a solution to this issue?

William Miteff
Tags (1)
1 REPLY
Enthusiast

Re: Dropping users

Before dropping the user, all objects in the user Db have to be cleaned up, you may use following syntax(TD 14.10):

DELETE USER user_name ALL;

DROP USER user_name;

There may be dead locks, as there might be other operations going at the time on the dictionary tables, which are holding locks on the DBC tables, leading to contention,You may submit the queries during off business hours or when batch users are not active.