Script to drop oracle DB users on HP, LINUX, SOLARIS

Shell Programming and Scripting
1

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;

Und another one to import all users all users who still get objects in one Table. And i suppose to do it before Friday 03th of July 09 Afternoon.
Thanks a lot in advance

Sincerly your

Sonson

2

Why not go to your Oracle admin interface and execute the SQL query from there?

3

Please all of you

i'm here because i need help like a shell script to do this on all unix server. i have allready my sql sript like ishow you. May be now please somedoby can help me.

Thank in Advance

Sonson