Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Grant sudo access to Oracle user for the named user account

Posted on 2015-02-13
6
Medium Priority
?
1,211 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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

FreeBSD on EC2 FreeBSD (https://www.freebsd.org) is a robust Unix-like operating system that has been around for many years. FreeBSD is available on Amazon EC2 through Amazon Machine Images (AMIs) provided by FreeBSD developer and security office…
Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
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.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Suggested Courses

609 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