DBA Hub

📋Steps in this guide1/1

Enable auditing in database

-- Auditing is disabled, when audit_trail is set to NONE,

oracle configurationintermediate
by OracleDba
14 views
1

Enable auditing in database

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
-- Auditing is disabled, when audit_trail is set to NONE,
SQL>
show parameter audit_trail
NAME               TYPE               VALUE
------------------------------------ ----------- --------------------------
audit_trail       string                NONE
- Either set audit_trail to DB or DB,EXTENDED.
alter system set audit_trail='DB' scope=spfile;
(or)
alter system set audit_trail='DB, EXTENDED' scope=spfile;
-- Restart the database.
shutdown immediate;
startup;
SQL>
show parameter audit_trail
NAME                 TYPE                   VALUE
------------------------------------ ----------- --------------------------
audit_trail           string               DB

Comments (0)

Please to add comments

No comments yet. Be the first to comment!