Views with the Prefix ALL (268)

Views with the prefix ALL refer to the user’s overall perspective of the database. These
views return information about schema objects to which the user has access through
public or explicit grants of privileges and roles, in addition to schema objects that the
user owns. For example, the following query returns information about all the objects
to which you have access:
SELECT owner, object_name, object_type FROM ALL_OBJECTS;

ALL字首檢視
以 ALL為字首的檢視反映了某個使用者所能看到的全部資料庫內容。其中除了包含使用者所擁有的方案物件之外，還包
含了使用者可訪問的公共物件，以及透過授予許可權或角色而能夠訪問的方案物件

[@more@]