[SOLVED] Logging via command as a certain user

szboardstretcher · 12-13-2016, 01:20 PM

No worries. You need to end the runuser line with a closing quote '

Code:

runuser -l exg85 -c '/export/home/exg85/reports/RUNUSEREXG85.sh'

trickydba · 12-13-2016, 01:21 PM

No permissions issue, had that resolved. The user 'exg85' has permission to execute every line in the script, but only when I do it manually. Put it in a script, it doesn't work

trickydba · 12-13-2016, 01:24 PM

@szboardstretcher...tried adding the closing quote, error I get is:

could not open session

szboardstretcher · 12-13-2016, 01:25 PM

What do you get with this?

runuser -l exg85 -c 'ls'

trickydba · 12-13-2016, 01:30 PM

Actually I made a mistake. I need to run this script:

#!/bin/bash
runuser -l exg85 -c '/export/home/exg85/reports/LINUX2WIN.sh'

That allows me to run this script as the user 'exg85':

#!/bin/bash

TODAY=$(date +%Y%m%d)
DIR0=//export/home/exg85/reports
DIR2=//export/home/exg85/reports/audit/reports

mkdir -p "${DIR2}"/"${TODAY}"
find "${DIR0}" -mindepth 1 -maxdepth 1 -type f -name "audit.xlsx" -mtime +1 -exec mv -t "${DIR2}"/"${TODAY}"/ "{}" \+

trickydba · 12-13-2016, 01:32 PM

@szboardstretcher........when I run

runuser -l exg85 -c 'ls'

under the username 'oracle' I get this:

could not open session

szboardstretcher · 12-13-2016, 01:35 PM

deleted

szboardstretcher · 12-13-2016, 01:37 PM

Can you sudo to that user from the oracle user?

As oracle 'sudo su - exg85' or 'sudo -u exg85 whoami'

trickydba · 12-13-2016, 01:38 PM

God knows I wish I could, but it would be a VERY HIGH security breach and once they find out, I will quickly get booted. The nature of my job is very secret and very sensitive!!

szboardstretcher · 12-13-2016, 01:40 PM

Dude! NO PROBLEM at all. Just doing my best to help. Some of my clients can, and some of my clients cant. Doesn't hurt to ask though. Try my code i mentioned in #23

trickydba · 12-13-2016, 01:41 PM

@szboardstretcher..no I can't. it asks for the 'oracle' password and I suspect that it is for the root user and I don't have the password for that

trickydba · 12-13-2016, 01:42 PM

You are VERY helpful and I appreciate it!!!!!

szboardstretcher · 12-13-2016, 01:45 PM

Ok.. How about:

Code:

(As oracle) su exg85 -c "yourscript.sh"

This will run the yourscript.sh as the user exg85.

No problem. On that note.. Please click the scales in the bottom left of each of my posts you find helpful,.. this increases my reputation and is one of the perks we enjoy for giving our time and effort. Its how we say thank you to one another!

trickydba · 12-13-2016, 01:49 PM

@szboardstretcher.......... it asks for a password, but when I put in both the password for 'oracle' and 'exg85' it says incorrect password. I typed them in VERY SLOOOOOOOOWLY too! 8.))

trickydba · 12-13-2016, 01:54 PM

I don't see scales but I clicked all your posts that were helpful where it says "Did you find this post helpful?" It's on the bottom right hand