Solved

Grant sudo access to Oracle user for the named user account

Posted on 2015-02-13
6
847 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
  • 3
  • 3
6 Comments
 
LVL 34

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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
LVL 34

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 34

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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

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…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
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.

810 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