Views with the Prefix USER (267)

The views most likely to be of interest to typical database users are those with the
prefix USER. These views:
■ Refer to the user’s own private environment in the database, including
information about schema objects created by the user, grants made by the user,
and so on
■ Display only rows pertinent to the user
■ Have columns identical to the other views, except that the column OWNER is
implied
■ Return a subset of the information in the ALL views
■ Can have abbreviated PUBLIC synonyms for convenience
For example, the following query returns all the objects contained in your schema:
SELECT object_name, object_type FROM USER_OBJECTS;

USER字首檢視
1. USER字首檢視有以下功能
* 反映了資料庫中某個使用者的全部情況
* 只展示和某個使用者相關的資訊
* 與其他檢視擁有相同的列，只有 OWNER 資訊是隱含的
* 其內容是以 ALL 為字首的檢視的子集
* 可以在其上建立經過縮寫的 PUBLIC 同義詞

[@more@]