Agile (MOSC)

MOSC Banner

Identifying missing privilege from SQL Debug output in STDOUT log

edited Aug 8, 2016 5:59AM in Agile (MOSC) 2 commentsAnswered ✓

Hi All,

Am facing a strange issue recently. In our 9.3.1.1 system, a particular user is unable to view the BOM table attributes in a particular subclass although required Read privileges are there in his profile.
What's more strange is that this issue is happening only in Prod environment & not lower one, whereas both have exactly same configuration settings. Basically the privileges were transported from lower environment to higher with ACP.

We have hundreds of privilege-mask in our system so it's extremely difficult to identify the root cause.

Can someone help me identify with any easy way the missing privileges ? I've tried by enabling debug level logging for SQL outputs in STDOUT log. But there are so many queries that am getting lost.

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