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

Sonson · #1 (**permalink**) 07-02-2009

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

Code:

 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

Neo · #2 (**permalink**) 07-02-2009

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

Sonson · #3 (**permalink**) 07-04-2009

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

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
lsnrctl start script for Oracle on Solaris	prakash.gr	Shell Programming and Scripting	4	06-14-2009 05:33 AM
Install Guide: Oracle Database 11 g Release 1 on Oracle Enterprise Linux 5	iBot	Oracle Updates (RSS)	0	09-11-2008 02:15 AM
Install Guide: Oracle Database 11g Release 1 on Oracle Enterprise Linux 5	iBot	Oracle Updates (RSS)	0	04-06-2008 05:10 AM
Drop Users	trfrye	UNIX for Dummies Questions & Answers	2	08-31-2005 03:39 PM
oracle database on solaris and linux	ganga	UNIX for Dummies Questions & Answers	3	11-27-2003 11:06 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by