Sponsored Content
Top Forums Shell Programming and Scripting Script to drop oracle DB users on HP, LINUX, SOLARIS Post 302330917 by Sonson on Thursday 2nd of July 2009 05:41:40 PM
Old 07-02-2009
Script to drop oracle DB users on HP, LINUX, SOLARIS

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
 

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

oracle database on solaris and linux

what is the difference in running oracle database on solaris and linux operating system (3 Replies)
Discussion started by: ganga
3 Replies

2. UNIX for Dummies Questions & Answers

Drop Users

I know that this is a really simple and stupid question, but how do I drop / disconnect a user who is logged in? AIX 5.2 (2 Replies)
Discussion started by: trfrye
2 Replies

3. Shell Programming and Scripting

lsnrctl start script for Oracle on Solaris

Hi, os version :sun solaris 5.9 I have a problem with one of production server where listener will die frequently, I have raised SR with oracle for the same, but mean time i need simple script and i need schedule in cron for every 5 min if listner will down it will start automatically. ... (4 Replies)
Discussion started by: prakash.gr
4 Replies

4. Solaris

Shell script to add users on solaris

Hi admins, I am trying to run a script to add users on solaris with password: I am using crypt for passwords: The part of my scripts is as below: if ; then echo "$username exists!" exit 1 else pass=$(perl -e 'print... (5 Replies)
Discussion started by: snchaudhari2
5 Replies

5. Solaris

T4-1/Solaris 11 and sudden 50% performance drop

We have a SPARC T4-1 server, running Solaris 11, and it's doing some pretty extensive parsing on roughly 100GB data set. All was well still few weeks ago, when I was testing the performance, I was reaching rougly 50minute calculation times, and it was more or less expected performance. Now... (0 Replies)
Discussion started by: julumme
0 Replies

6. Solaris

How to access Oracle DB on Linux from Solaris?

What I am trying to do is install Remedy on a Solaris machine. However to install Remedy on Solaris, the server has to be able to connect to the oracle database on the Linux server? How can I accomplish this? (8 Replies)
Discussion started by: newborndba
8 Replies

7. Shell Programming and Scripting

Migrating Oracle on Solaris Sparc to Linux RHEL 7 VM

Hi Gurus, We are migrating Oracle from Solaris to RHEL 7 and looking for Solaris equivalent commands for Linux. we are using lot of korn shell scripts built on Solaris so, i am looking for equivalent commands which are using in Solaris.. Could you please help me here by proving any info... (1 Reply)
Discussion started by: mssprince
1 Replies

8. Red Hat

Migrating Oracle on Solaris Sparc to Linux RHEL 7 VM

Hi Gurus, We are migrating Oracle from Solaris to RHEL 7 and looking for Solaris equivalent commands for Linux. we are using lot of korn shell scripts built on Solaris so, i am looking for equivalent commands which are using in Solaris.. Could you please help me here by proving any info ... (4 Replies)
Discussion started by: mssprince
4 Replies
ftphosts(4)							   File Formats 						       ftphosts(4)

NAME
ftphosts - FTP Server individual user host access file SYNOPSIS
/etc/ftpd/ftphosts DESCRIPTION
The ftphosts file is used to allow or deny access to accounts from specified hosts. The following access capabilities are supported: allow username addrglob [addrglob...] Only allow users to login as username from host(s) that match addrglob. deny username addrglob [addrglob...] Do not allow users to login as username from host(s) that match addrglob. A username of * matches all users. A username of anonymous or ftp specifies the anonymous user. addrglob is a regular expression that is matched against hostnames or IP addresses. addrglob may also be in the form address:netmask or address/CIDR, or be the name of a file that starts with a slash ('/') and contains additional address globs. An exclamation mark (`!') placed before the addrglob negates the test. The first allow or deny entry in the ftphosts file that matches a username and host is used. If no entry exists for a username, then access is allowed. Otherwise, a matching allow entry is required to permit access. EXAMPLES
You can use the following ftphosts file to allow anonymous access from any host except those on the class A network 10, with the exception of 10.0.0.* IP addresses, which are allowed access: allow ftp 10.0.0.* deny ftp 10.*.*.* allow ftp * 10.0.0.* can be written as 10.0.0.0:255.255.255.0 or 10.0.0.0/24. FILES
/etc/ftpd/ftphosts ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWftpr | +-----------------------------+-----------------------------+ |Interface Stability |External | +-----------------------------+-----------------------------+ SEE ALSO
in.ftpd(1M), ftpaccess(4), attributes(5) SunOS 5.11 1 May 2003 ftphosts(4)
All times are GMT -4. The time now is 07:50 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy