如何開(kāi)啟和關(guān)閉oracle數(shù)據(jù)庫(kù)中的審計(jì)功能

在oracle11g中，數(shù)據(jù)庫(kù)的審計(jì)功能是默認(rèn)開(kāi)啟的（這和oracle10g的不一樣，10g默認(rèn)是關(guān)閉的），

創(chuàng)新互聯(lián)專(zhuān)注于企業(yè)全網(wǎng)整合營(yíng)銷(xiāo)推廣、網(wǎng)站重做改版、兗州網(wǎng)站定制設(shè)計(jì)、自適應(yīng)品牌網(wǎng)站建設(shè)、html5、商城建設(shè)、集團(tuán)公司官網(wǎng)建設(shè)、成都外貿(mào)網(wǎng)站建設(shè)公司、高端網(wǎng)站制作、響應(yīng)式網(wǎng)頁(yè)設(shè)計(jì)等建站業(yè)務(wù)，價(jià)格優(yōu)惠性?xún)r(jià)比高，為兗州等各大城市提供網(wǎng)站開(kāi)發(fā)制作服務(wù)。

oracle11gr2的官方文檔上寫(xiě)的是錯(cuò)的，當(dāng)上說(shuō)default是none，而且是審計(jì)到db級(jí)別的，這樣就會(huì)

往aud$表里記錄統(tǒng)計(jì)信息。

1.如果審計(jì)不是必須的，可以關(guān)掉審計(jì)功能；

sql

show

parameter

audit_trail;

name

type

value

------------------------------------

-----------

------------------------------

audit_trail

string

db

sql

alter

system

set

audit_trail=none

scope=spfile;

sql

shut

immediate;

sqlstartup

2.刪除已有的審計(jì)信息

可以直接truncate表aud$,

truncate

table

sys.aud$;

3.或者將aud$表移到另外一個(gè)表空間下，以減少system表空間的壓力和被撐爆的風(fēng)險(xiǎn)。

附：11g中有關(guān)audit_trail參數(shù)的設(shè)置說(shuō)明：

audit_trail

property

description

parameter

type

string

syntax

audit_trail

=

{

none

|

os

|

db

[,

extended]

|

xml

[,

extended]

}

default

value

none

modifiable

no

basic

no

audit_trail

enables

or

disables

database

auditing.

values:

none

disables

standard

auditing.

this

value

is

the

default

if

the

audit_trail

parameter

was

not

set

in

the

initialization

parameter

file

or

if

you

created

the

database

using

a

method

other

than

database

configuration

assistant.

if

you

created

the

database

using

database

configuration

assistant,

then

the

default

is

db.

os

directs

all

audit

records

to

an

operating

system

file.

oracle

recommends

that

you

use

the

os

setting,

particularly

if

you

are

using

an

ultra-secure

database

configuration.

db

directs

audit

records

to

the

database

audit

trail

(the

sys.aud$

table),

except

for

records

that

are

always

written

to

the

operating

system

audit

trail.

use

this

setting

for

a

general

database

for

manageability.

if

the

database

was

started

in

read-only

mode

with

audit_trail

set

to

db,

then

oracle

database

internally

sets

audit_trail

to

os.

check

the

alert

log

for

details.

db,

extended

performs

all

actions

of

audit_trail=db,

and

also

populates

the

sql

bind

and

sql

text

clob-type

columns

of

the

sys.aud$

table,

when

available.

these

two

columns

are

populated

only

when

this

parameter

is

specified.

if

the

database

was

started

in

read-only

mode

with

audit_trail

set

to

db,

extended,

then

oracle

database

internally

sets

audit_trail

to

os.

check

the

alert

log

for

details.

xml

writes

to

the

operating

system

audit

record

file

in

xml

format.

records

all

elements

of

the

auditrecord

node

except

sql_text

and

sql_bind

to

the

operating

system

xml

audit

file.

xml,

extended

performs

all

actions

of

audit_trail=xml,

and

populates

the

sql

bind

and

sql

text

clob-type

columns

of

the

sys.aud$

table,

wherever

possible.

these

columns

are

populated

only

when

this

parameter

is

specified.

you

can

use

the

sql

audit

statement

to

set

auditing

options

regardless

of

the

setting

of

this

parameter.

如何開(kāi)啟數(shù)據(jù)庫(kù)里某USER所有表的審計(jì)

您好，不知道你的數(shù)據(jù)庫(kù)是什么？

Oracle的審計(jì)是放到AUD$表里面，需要sys權(quán)限。

查詢(xún)審計(jì)：

select * from sys.aud$;

select returncode, action#, userid, userhost, terminal,timestamp from aud$。

SYS.AUD$ 是唯一保留審計(jì)結(jié)果的表。其它的都是視圖。

STMT_AUDIT_OPTION_MAP 包含有關(guān)審計(jì)選項(xiàng)類(lèi)型代碼的信息由SQL.BSQ 腳本在CREATEDATABASE 的時(shí)候創(chuàng)建

AUDIT_ACTIONS 包含對(duì)審計(jì)跟蹤動(dòng)作類(lèi)型代碼的說(shuō)明

ALL_DEF_AUDIT_OPTS 包含默認(rèn)對(duì)象審計(jì)選項(xiàng)。當(dāng)創(chuàng)建對(duì)象時(shí)將應(yīng)用這些選項(xiàng)

DBA_STMT_AUDIT_OPTS 描述由用戶(hù)設(shè)置的跨系統(tǒng)的當(dāng)前系統(tǒng)審計(jì)選項(xiàng)

DBA_PRIV_AUDIT_OPTS 描述由用戶(hù)正在審計(jì)的跨系統(tǒng)的當(dāng)前系統(tǒng)權(quán)限

DBA_OBJ_AUDIT_OPTS 描述在所有對(duì)象上的審計(jì)選項(xiàng)

USER_OBJ_AUDIT_OPTS USER 視圖描述當(dāng)前用戶(hù)擁有的所有對(duì)象上的審計(jì)選項(xiàng)

以下是審計(jì)記錄

DBA_AUDIT_TRAIL 列出所有審計(jì)跟蹤條目

USER_AUDIT_TRAIL USER視圖顯示與當(dāng)前用戶(hù)有關(guān)的審計(jì)跟蹤條目

DBA_AUDIT_OBJECT 包含系統(tǒng)中所有對(duì)象的審計(jì)跟蹤記錄

USER_AUDIT_ OBJECT USER 視圖列出一些審計(jì)跟蹤記錄而這些記錄涉及當(dāng)前用戶(hù)可以訪(fǎng)問(wèn)的對(duì)象的語(yǔ)句

DBA_AUDIT_SESSION 列出涉及CONNECT 和DISCONNECT 的所有審計(jì)跟蹤記錄

USER_AUDIT_ SESSION USER視圖列出涉及當(dāng)前用戶(hù)的CONNECT 和DISCONNECT 的所有審計(jì)跟蹤記錄

DBA_AUDIT_STATEMENT 列出涉及數(shù)據(jù)庫(kù)全部的GRANT REVOKE AUDIT NOAUDIT 和ALTER SYSTEM 語(yǔ)句的審計(jì)跟蹤記錄

USER_ AUDIT_ STATEMENT 對(duì)于USER 視圖來(lái)說(shuō)這些語(yǔ)句應(yīng)是用戶(hù)發(fā)布的

DBA_AUDIT_EXISTS 列出BY AUDIT NOT EXISTS 產(chǎn)生的審計(jì)跟蹤條目

下面的視圖用于細(xì)粒度審計(jì)

DBA_AUDIT_POLICIES 顯示系統(tǒng)上的所有審計(jì)策略

DBA_FGA_AUDIT_TRAIL 列出基于值的審計(jì)的審計(jì)跟蹤記錄。

在oracle中開(kāi)啟審計(jì)功能

sqlplus "/ as sysdba"

show parameter audit

alter system set audit_sys_operations=TRUE scope=spfile;

alter system set audit_trail=DB scope=spfile;

shutdown immediate;

startup force;

Oracle 11g起audit是自動(dòng)開(kāi)啟的。我很煩這個(gè)審計(jì)開(kāi)啟，審計(jì)日志半個(gè)月10G，煩煩煩。我一把都關(guān)閉Oracle的審計(jì)功能，提高Oracle的空閑率。

網(wǎng)站題目：oracle怎么啟用審計(jì),開(kāi)啟oracle數(shù)據(jù)庫(kù)審計(jì)功能
文章地址：http://jinyejixie.com/article42/hsicec.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供品牌網(wǎng)站制作、服務(wù)器托管、網(wǎng)站設(shè)計(jì)公司、小程序開(kāi)發(fā)、動(dòng)態(tài)網(wǎng)站、網(wǎng)站維護(hù)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶(hù)投稿、用戶(hù)轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話(huà)：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)