Database Administration (MOSC)

MOSC Banner

User A (locked) is being audited when expdp is run by user B

edited Feb 2, 2021 1:43AM in Database Administration (MOSC) 10 commentsAnswered

IBM AIX on POWER S 7.1 --- After upgrade from 12.1 to 12.2

2 users in question-- A and B

  A is locked (full audit)

  B --runs the export from different schema ( not audited)

 All the privileges user B has is connect , resource , import full db , export full db

SQL> CREATE USER "B" identified by "Test#2021"

DEFAULT TABLESPACE "USERS"

TEMPORARY TABLESPACE "TEMP"; 2 3

User created.

SQL> grant "RESOURCE","DATAPUMP_EXP_FULL_DATABASE","CONNECT" to B;


 When the export is run -- ./expdp parfile=/home/oracle/backup_test.par

   we see in the audit logs generated with the username A  

----

Trying to understand why when expdp is run --it is pulling the Username as A

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