Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Sudo as Oracle
Operating Systems Linux Red Hat Sudo as Oracle Post 302950845 by jegaraman on Wednesday 29th of July 2015 10:12:10 AM
Old 07-29-2015
Sudo as Oracle
Dear all ,

Very recently , for audit purpose , we want to avoid generic users like "oracle" for login to our Database Server.
So we create a sudo user "db_user".
But while running sqlplus , we want to switch to user "oracle" and execute it .

Here we dont want to give , password of oracle , rather than ,we need to give sudo password ( which is "db_user" password. )

But sudo to root is possible like "sudo -i"

But sudo to oracle is not possible ,

any ideas please.
 

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Unable to use the Sudo command. "0509-130 Symbol resolution failed for sudo because:"

Hi! I'm very new to unix, so please keep that in mind with the level of language used if you choose to help :D Thanks! When attempting to use sudo on and AIX machine with oslevel 5.1.0.0, I get the following error: exec(): 0509-036 Cannot load program sudo because of the following errors:... (1 Reply)
Discussion started by: Chloe123
1 Replies

2. Cybersecurity

sudo /bin/sh or sudo su -

we are looking at changing the way we get root on our network. in our current system if an admin needs root access he just gets the root password and uses an su. some of our staff have decided that a sudo to "/bin/sh" will be easer. some of our staff think a sudo to "su -" will be better. I... (0 Replies)
Discussion started by: robsonde
0 Replies

3. AIX

sudo log and sudo auditing

Sudo In AIX, how to find out what commands have been run after a user sudo to another user? for example, user sam run 'sudo -u robert ksh' then run some commands, how can I (as root) find what commands have been run? sudo.log only contains sudo event, no activity logging. (3 Replies)
Discussion started by: jalite19
3 Replies

4. Shell Programming and Scripting

ssh foo.com sudo command - Prompts for sudo password as visible text. Help?

I am writing a BASH script to update a webserver and then restart Apache. It looks basically like this: #!/bin/bash rsync /path/on/local/machine/ foo.com:path/on/remote/machine/ ssh foo.com sudo /etc/init.d/apache2 reloadrsync and ssh don't prompt for a password, because I have DSA encryption... (9 Replies)
Discussion started by: fluoborate
9 Replies

5. Shell Programming and Scripting

sudo: sorry, you must have a tty to run sudo

Hi All, I running a unix command using sudo option inside shell script. Its working well. But in crontab the same command is not working and its throwing "sudo: sorry, you must have a tty to run sudo". I do not have root permission to add or change settings for my userid. I can not even ask... (9 Replies)
Discussion started by: Apple1221
9 Replies

6. Shell Programming and Scripting

sudo: sorry, you must have a tty to run sudo

Hi, Have a need to run the below command as a "karuser" from a java class which will is running as "root" user. When we are trying to run the below command from java code getting the below error. Command: sudo -u karuser -s /bin/bash /bank/karunix/bin/build_cycles.sh Error: sudo: sorry,... (8 Replies)
Discussion started by: Satyak
8 Replies

7. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies

LEARN ABOUT DEBIAN

jifty::dbi::handle::oracle

Jifty::DBI::Handle::Oracle(3pm) 			User Contributed Perl Documentation			   Jifty::DBI::Handle::Oracle(3pm)

NAME

	 Jifty::DBI::Handle::Oracle - An oracle specific Handle object

SYNOPSIS

DESCRIPTION

       This module provides a subclass of Jifty::DBI::Handle that compensates for some of the idiosyncrasies of Oracle.

METHODS

   connect PARAMHASH: Driver, Database, Host, User, Password
       Takes a paramhash and connects to your DBI datasource.

   database_version
       Returns value of ORA_OCI constant, see "Constants" in DBD::Oracle.

   insert
       Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.

   build_dsn PARAMHASH
       Takes a bunch of parameters:

       Required: Driver, Database or Host/SID, Optional: Port and RequireSSL

       Builds a dsn suitable for an Oracle DBI connection

   blob_params column_NAME column_type
       Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type.  The current
       Oracle implementation only supports ORA_CLOB types(112).

   apply_limits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
       takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;

   distinct_query STATEMENTREF
       takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.

AUTHOR

       Jesse Vincent, jesse@fsck.com

SEE ALSO

       Jifty::DBI, Jifty::DBI::Handle, DBD::Oracle

perl v5.14.2							    2011-04-26					   Jifty::DBI::Handle::Oracle(3pm)
All times are GMT -4. The time now is 07:57 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy