sudo users within Oracle database
353151Apr 13 2009 — edited Apr 13 2009Hi, I know this might sound a little strange, but I thought someone might have been thru a similar situation, if not the same.
Our application has following users.
app0 (schema owner)
app0feed ( db account that is used to run feeds)
app0web ( db account used by the web app).
So when we clone our prod db for testing purposes, we want to be able to track individual users that are operating on these test databases.
We let users use app0, app0feed, app0web logins into these Test databases to do their work, running feeds etc, all these users don't have individual logins for these database so when they login to these test databases it's difficult for us to track the things that they do when they are dealing prod data.
Even though they login with app users we can easily identify them from the machine-name, program and other fields on v$session.
But I was wondering if there was anyway we can have them be themselves be able to do things as app0feed and app0web ( just like sudo on unix).
Where we sudo as Oracle to do DB admin related work on DB hosts.
Ofcourse I can grant all the privs that app0feed or app0web had to these individual users, but it's just duplicating things....so thought if there was anything similar to sudo, I have not come across any but thought someone might have had similar request.
Thanks in Advance
Ramki