Oracle data dictionary view

xiaoxiao2021-03-06  108

The view of the data dictionary is available for all users, and the displayed information is the privilege range of the user who issues a query; the prefix is ​​available for users with the SELECT ANY TABLE system permission, The information displayed is about all information about the database; the prefix is ​​available for all users, and the displayed information is a description of the user who issues a query; the prefix is ​​a view as a virtual view, during the database operation Create, observe.

The following table is in parentheses indicating the prefix that can be tested, and some USER prefix visits can be represented by a gear name, and a parentheses use a parentheses in the table in the User view.

View Description 2PC_Neighbors (DBA_) The incoming distributed distributed transaction comes in and out connection information 2PC - Pending (DBA_) Uncommitted distributed transaction information Audit_Actions audit tracking action number and description correspondence Audit_exists (dba_) with audit exists command Get the audit tracking entrance

Audit_Object (DBA_, USER) Audit Tracking Inlet for the Audit_Session (DBA_, User) Database Session of the Audited Database Object

转载请注明原文地址:https://www.9cbs.com/read-125806.html

New Post(0)