Hi everybody,

i need help from all of you.

I have many users who are no more work in our Company. Some who get objects are Locked. There Many users and many Database Servers. And it'll take long for me to finished this job.

That's why i need your help to provide me anyone Scripts for(HP,LINUX,SOLARIS) which drop all users who don't have any objects in all databases on all oracle Server.

Hier his my Sql script which i want to combine your help Script

 select   username, count (object_name)
    from   all_users, all_objects
   where   username = owner(+)
group by   username
  having   count (object_name) = 0;