Sponsored Content
Top Forums Shell Programming and Scripting Accessing Databse through OS Authentication Post 302242937 by Ravi oruganti on Friday 3rd of October 2008 08:18:27 AM
Old 10-03-2008
Accessing Databse through OS Authentication

I have defined the connectivity details to the oracle database in a file env.ksh as follows
DBNAME=$INST_NAME
USERID="use_x"
PASSWORD="cccccc"
When ever i want to connect to the database from a shellscript ,i am running this file from the shell script as follows
# Export the environment varibles.
. /app/gsl/bin/env.ksh

Due to security reasons , we need to implement the OS authentication mechanism so that user id password should not be maintained in a file.
Instead , when the user logs into unix he should be able to access oracle without specifying the userid/password.

can anybody let me know how to achieve that.
cheers
Ravi.
 

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

databse startup problem

i have oracle database startup problem. i have installed oracle8i(8.1.7) on windowsXP i have configured everything properly but i m unable to start database automatically and for this when i checked services of database it shows starting not started so i have to start it manually.Can u plz tell... (3 Replies)
Discussion started by: vandana
3 Replies

2. UNIX for Dummies Questions & Answers

Accessing NTFS...

Hi, This may be a stupid question, but I want to get a confirmation from experts. After some painful attempts I was able to successfully dual boot RH Linux 7.3 with the Win XP hp factor install. (I used Partition Magic 8 from WinXP for creating the ext3 partitions) I have now a nice grub... (3 Replies)
Discussion started by: Vishnu
3 Replies

3. Programming

databse

i am including #include<sqlext.h> #include<sql.h> while writing a program for database connection in c++ (not visual c++) the compiler is giving error in both my question is while allocating the environment or while creating a database connection in c++ which header files do we need ... (4 Replies)
Discussion started by: ramneek
4 Replies

4. UNIX for Advanced & Expert Users

Need a script for uploading data from unix box to mysql databse

how to upload system information(unix box) to MySql database's(running in another unix box) respective tables using a script only..i.e once script runs all the informations like hostid,hostna,disks,cpu etc get stored to respective tables of MySql database.... (2 Replies)
Discussion started by: shubhendu.pyne
2 Replies

5. UNIX for Advanced & Expert Users

Accessing switch

Hello Community! Anyone knows how can I access the switch for monitoring the traffic on my LAN? The switch is a Linksys sr2024 Thanks in advance (1 Reply)
Discussion started by: ncatdesigner
1 Replies

6. Debian

Connect MySQL databse to debian

Hello, I wont to connect a MySQL database to debian: I have installed libmyodbc package and after i have configured /etc/odbcinst.ini: Description = MySQL driver Driver = /usr/lib/odbc/libmyodbc.so Setup = /usr/lib/odbc/libodbcmyS.so and /etc/odbc.ini : Description =... (0 Replies)
Discussion started by: linux31
0 Replies

7. Shell Programming and Scripting

Korn shell to insert cyrillic characters into the databse

i have written a shell script that reads a csv file and inserts tokenized strings into the database. the problem comes when the csv file has cyrillic characters. how do i set the parameters in my shell script(korn shell) so that any characters can be inserted into the database. (3 Replies)
Discussion started by: vkca
3 Replies

8. UNIX Desktop Questions & Answers

How can I replicate master master and master master MySQL databse replication and HA?

I have an application desigend in PHP and MySQl running on apache web server that I is running on a Amazon EC2 server Centos. I want to implement the master-master and master slave replication and high availability disaster recovery on this application database. For this I have created two... (0 Replies)
Discussion started by: Palak Sharma
0 Replies
mysql_import_combined_log.pl(1) 			      General Commands Manual				   mysql_import_combined_log.pl(1)

NAME
mysql_import_combined_log.pl - Imports an Apache combined log into a MySQL database. SYNOPSIS
mysql_import_combined_log.pl -d <database name> -t <table name> [-h <host name>] [-u <user name>] [-p <password>] [-f <filename>] OPTIONS
--host|-h <host name> The host to connect to. Default is localhost. --database|-d <database name> The database to use. Required. --username|-u <username> The user to connect as. --password|-p <password> The user's password. --table|-t <table name> The name of the table in which to insert data. --logfile|-f <file name> The file to read from. If not given, data is read from stdin. --help|-? Print out this help message. --version Print out the version of this software. AUTHOR
Aaron Jenson Updated to work under Perl 5.6.1 by Edward Rudd MAN PAGE CREATED BY
Michael A. Toth <lirul.lists@gmail.com> - based on content of script COMMENTS
This man page was written using xml2man (1) by the same author. Manuals User mysql_import_combined_log.pl(1)
All times are GMT -4. The time now is 11:12 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy