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
IFX_CONNECT(3)								 1							    IFX_CONNECT(3)

ifx_connect - Open Informix server connection

SYNOPSIS
resource ifx_connect ([string $database], [string $userid], [string $password]) DESCRIPTION
ifx_connect(3) establishes a connection to an Informix server. In case a second call is made to ifx_connect(3) with the same arguments, no new link will be established, but instead, the link identifier of the already opened link will be returned. The link to the server will be closed as soon as the execution of the script ends, unless it's closed earlier by explicitly calling ifx_close(3). PARAMETERS
All of the arguments are optional, and if they're missing, defaults are taken from values supplied in php.ini (ifx.default_host for the host (Informix libraries will use INFORMIXSERVER environment value if not defined), ifx.default_user for user, ifx.default_password for the password (none if not defined). o $database - The database name, as a string. o $userid - The username, as a string. o $password - The password, as a string. RETURN VALUES
Returns a connection identifier on success, or FALSE on error. EXAMPLES
Example #1 Connect to a Informix database <?php $conn_id = ifx_connect ("mydb@ol_srv1", "imyself", "mypassword"); ?> SEE ALSO
ifx_pconnect(3), ifx_close(3). PHP Documentation Group IFX_CONNECT(3)
All times are GMT -4. The time now is 05:57 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy