?
Solved

Grant sudo access to Oracle user for the named user account

Posted on 2015-02-13
6
Medium Priority
?
1,447 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 36

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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
LVL 36

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 36

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

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This installment of Make It Better gives Media Temple customers the latest news, plugins, and tutorials to make their Grid shared hosting experience that much smoother.
Welcome back to our beginners guide of the popular Unix tool, cron. If you missed part one where we introduced this tool, the link is below. We left off learning how to build a simple script to schedule automatic back ups. Now, we’ll learn how to se…
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.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

569 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