?
Solved

Grant sudo access to Oracle user for the named user account

Posted on 2015-02-13
6
Medium Priority
?
1,106 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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
The purpose of this article is to demonstrate how we can use conditional statements using Python.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.
Suggested Courses
Course of the Month8 days, 14 hours left to enroll

764 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