Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Accessing Databse through OS Authentication

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Accessing Databse through OS Authentication
# 1  
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.
# 2  
Old 10-03-2008
ORACLE-BASE - OS Authentication
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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
Login or Register to Ask a Question