Grant sudo access to Oracle user for the named user account

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.

Thanks John.

How can I add an entry to this sudoers file?

I'm getting this error now

Sorry, user sve is not allowed to execute '/usr/bin/su - oracle' as root on servername

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.

Thanks it works now...