Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sudo users within Oracle database

353151Apr 13 2009 — edited Apr 13 2009
Hi, 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 11 2009
Added on Apr 13 2009
3 comments
1,065 views