Database Administration (MOSC)

MOSC Banner

audt select on dictionary views

edited Dec 28, 2018 4:19PM in Database Administration (MOSC) 6 commentsAnswered

Hi

Is it possible to audit selects on dictionary views executed by certain user ?

I've user, "USERA" . This user has been granted select_catalog_role, so he is able to execute "select username from dba_users;"

As sysdba , I executed  following to audit USERA :

audit select any table by  USERA by access

audit select any dictionary by USERA by access

However  audit trail does not contain  selects executed by USERA on dictionary views

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center