Solved

Grant sudo access to Oracle user for the named user account

Posted on 2015-02-13
6
1,024 Views
Last Modified: 2015-02-13
Experts -

I've a AIX ver 6.

How can I give the named user account to access oracle user account using SUDO?

Currently I'm getting this error when using sudo.

$ sudo su - oracle

Password:
sve is not in the sudoers file.  This incident will be reported.


Thanks,
Sve
0
Comment
Question by:sventhan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 35

Expert Comment

by:johnsone
ID: 40608626
The user sve would have to be added to the /etc/sudoers file.

Once that is done, you should be allowed to run the command.  However, you are running it incorrectly.  You should not be issuing the su command.  You should be doing something like this:

sudo -u oracle cmd

Where cmd is the command you want to run as the oracle user.
0
 
LVL 18

Author Comment

by:sventhan
ID: 40608638
Thanks John.

How can I add an entry to this sudoers file?
0
 
LVL 18

Author Comment

by:sventhan
ID: 40608707
I'm getting this error now

Sorry, user sve is not allowed to execute '/usr/bin/su - oracle' as root on servername
0
Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

 
LVL 35

Expert Comment

by:johnsone
ID: 40608708
It is a plain text file.  You just need to edit it.  You need root access to edit it though so it is typically something that you need to request from your system administrators.
0
 
LVL 35

Accepted Solution

by:
johnsone earned 500 total points
ID: 40608712
Correct.  su is not a command that you are allowed to execute with sudo.  That effectively negates the auditing capabilities of using the sudo command.
0
 
LVL 18

Author Closing Comment

by:sventhan
ID: 40608763
Thanks it works now...
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to take different types of Oracle backups using RMAN.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question