Dear all,
On our database audit parameter is db extended, and audit informations was reside on system tablespace.
For some reasons we enable audit for specific user.
AUDIT ALL BY TOMMY BY ACCESS;
AUDIT DELETE TABLE, INSERT TABLE, SELECT TABLE, UPDATE TABLE BY TOMMY BY ACCESS;
AUDIT EXECUTE ANY PROCEDURE BY TOMMY BY ACCESS;
There is writing too much information and we want disable this audit for tommy. But we want doing it without restart database because our system 7/24 running.
we enable audit for tommy without restart but we cannot disable it without restart.
NOAUDIT ALL BY TOMMY;
NOAUDIT DELETE TABLE, INSERT TABLE, SELECT TABLE, UPDATE TABLE BY TOMMY;
NOAUDIT EXECUTE ANY PROCEDURE BY TOMMY;
there is no any error but it steel writting too much information, please help how we can disable it without restart?