Database Security Products (MOSC)

MOSC Banner

How to Identify users using a shared global schema in Enterprise User Security

edited Aug 6, 2012 6:04PM in Database Security Products (MOSC) 2 commentsAnswered
So we are setting up Oracle Enterprise User Security using a global schema. One question that arises if I have ten users that  are using the global schema to sign on and run queries in a database.  If lets say ten users are running ten queries and one is bad. How do I tell which user it is? If the global schema is READONLY. When looking at the v$session table they will show the user as READONLY. How can I find out it is testuser1 or testuser2?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center