1. Audit (Audit): The tracking records of the database activities performed by the user are easy to supervise and inspect afterwards.Audit Information storage location:Audit record information that is stored in the SYS in the system table space . aud$ data dictionary table; or the operating system default location $ORACLE _base/admin/$
V $ Database: database information, such as the database name and creation time.
V $ instance information, such as Instance name and start time.
V $ parameter information, select * from V $ parameter where name like '% name' ----> show parameter name (executed in sqlplus)
V $ process: Information about processes running, such as PID, spid, and process name, such as SMON and pmon. in windows, a process similar to Oracle is displayed. the name of a thre
. Dba_thresholds the upper value of the warning. How many alarms are used for the tablespace. The background process Mmon monitors this information. Dba_outstanding_alerts last 10 warning messages. Dba_alert_history historical information about the warning. Table: System_privilege_map, system permissions information, such as SYSDBA and sysoper that are frequently used, are system permissions. Also like create Tablespace,drop tablespace, note that the drop table is not a system permission, and th
Tags: Oracle audit auditAuditing (Audit) is used to monitor database operations performed by users, and audit records can exist in data dictionary tables called Audit Records: SYS stored in the system table space. aud$ tables, which can be viewed dba_audit_trail view) or ope
[Oracle] database security-audit Oracle audit is an afterthought task. After a database security problem occurs, you can trace the source of the problem to locate and discover it. Oracle audit mainly includes the following three p
Oracle provides an audit tool for tracking, recording, and counting all aspects of database activities! -- Sqlserver does not seem to have this function yet!
Oracle audit functions
Initialized parameter control: built-in Database Audit
Detailed
Oracle Audit Vault and Database Firewall 12.2 new featuresThe backup recovery components of the Audit Vault server are integrated into the AVDF product. When the Audit Vault Agent (audit agent) restarts or AVDF upgrades are received, Aud
I. Classification of audits:
Oracle Audit in general can be divided into "standard audit" and "fine-grained audit" the latter also known as "policy-based Audit", after the oracle10g function has been greatly enhanced. Standard audit
Oracle 11g audit files
Audit:
The audit option enabled by default for Oracle 11g. The default value of AUDIT_TRAIL is DB, which indicates that audit data will be recorded in the base table of the
users only need to set audit_sys_operations to true; for unix users, audit_file_dest is also required ):
SQL> show parameter audit
NAME TYPE VALUE---------------------------------------------------------------------------------------------------Audit_file_dest string D: \ ORACLE \ PRODUCT \ 10.2.0 \ ADMIN \ ORCL \ ADUMPAudit_sys_operations boolean TRUEAudit_trail string DBSQL>
Metalink explanation:
Excepti
Tags: Oracle training Oracle Database tutorial Oracle Video Oracle Tutorial Oracle Video TutorialOracle Video Tutorial GoalsOracle Video tutorial, wind Brother this set of Oracle Tutorials Training Learning
Q. 1: What feature in oracle allows you to monitor Suspicious Activity on the Datbase
1. Replication
2. Auditing
3. Monitoring
4. Tuning
Q. 2: Auditing can be turned on by setting this parameter
1. DB_AUDIT_TRAIL
2. AUDIT_TRAIL
3. AUDIT_DB
4. None of the above
Q. 3: What are the valid values for AUDIT_TRAIL Parameter
1. DB
2. OS
3. NONE
4. All of the above
Q. 4: Where are the records stored if the following value is set in the P
Label:About audits: 11g By default, the auditing option is enabled, and the default value of the Audit_trail parameter is DB, which indicates that the audit data will be recorded on the sys.aud$ Audit Dictionary base table in the database. In Oracle 10g, the default value of this parameter is none, which means that auditing is not enabled.
This section is translated from Oracle metalink doc: 167293.1. An example is provided to illustrate ORACLE audit usage.
ORACLE audits can be performed at the statement, object, and permission levels. Similarly, SYSDBA and SYSOPER user behavior can also be audited (from ORACLE
Audit is used to monitor the database operations performed by users. Oracle stores Audit trail results in OS files or databases.
1. To use audit, you must activate audit.
SQL> conn/as sysdba is connected. SQL> show parame
Oracle FGA Audit
You may be familiar with trigger, but Oracle also has a function named FGA. It works like trigger, but it is more powerful. its full name is Fine-Grained Audit, which is a special method of Audit. to use FGA, you only need to call the
Tags: oracle ora 09925Solaris under Oracle RAC ORA-09925 Unable to create audit--no spaceReceived development response, sqlplus or Developer tools Landing Database error, unable to login, as follows:650) this.width=650; "title=" Qq20140806151657.png "src=" http://s3.51cto.com/wyfs02/M02/44/7F/ Wkiol1ph17actp71aaeshwvrok0976.jpg "alt=" Wkiol1ph17actp71aaeshwvrok09
Ora 01653[HTML]View PlainCopy
[Email Protected]:/myimp/aud> sqlplus yy/[email protected]:1521/xxxx
Sql*plus:release 11.2.0.4.0 Production on Mon APR 25 10:04:32 2016
Copyright (c) 1982, Oracle. All rights reserved.
ERROR:
Ora-00604:error occurred at recursive SQL level 1
Ora-01653:unable to extend table SYS. aud$ by 8192 in Tablespace SYSTEM
Ora-02002:error while writing to audit
Rollback Segment InformationDba_ts_quotas User table Space quota informationDba_free_space Database Free Space informationDba_profiles Database User Resource limit informationDba_sys_privs User's system permissions informationDba_tab_privs the object permission information that the user hasDBA_COL_PRIVS user has Column object permission informationDba_role_privs The role information that the user hasDba_audit_trail Audit
/app/oracle/admin/mydb /adump audit_sys_operations booleanfalse audit_syslog_level string audit_trail stringnone Sql>altersystemsetaudit_ trail=db,extendedscope=spfile;2 , restart the databasestatic parameters, which need to be restarted in order for the parameters to take effectsql>shutdownimmediate;
Databaseclosed.
Databasedismounted.
Oracleinstanceshutdown.
Sql>startup oracleinstancestarted. Totalsys
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.